I've had to do this a couple of times with some sites having 10s of thousands of records in their wp_options. Most records are prefixed with a plug-in name, you can just search %pluginname_% and in my experience it's only a handful of plugins that write such a volume of records to wp_options.