On Mon, Nov 14, 2005 at 07:46:51AM -0800, jennyw wrote: > We've heard that PostgreSQL can do fuzzy search, but haven't had much > luck. I'm brand new to PostgreSQL, so this might be completely obvious > for an experienced user. > > Are there any how-tos on fuzzy text searching? Someone said to try using > tsearch2, but it seems that it does full-text searching, but not fuzzy > search. Ideally, we'd like to use that w/ a fuzzy search option. In > particular, if someone searches for "imat" we want to return results > including "immaterial" and "imaterial" (so misspellings plus partial match).
In the contrib directory, there is a directory fuzzystrmatch which includes code for various forms of fuzzy matching. Good luck. -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
pgpC6GZE6OlFv.pgp
Description: PGP signature
