From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | jennyw <jennyw(at)dangerousideas(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Fuzzy text search |
Date: | 2005-11-14 16:09:35 |
Message-ID: | 20051114160933.GE15381@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)svana(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Hannes Dorbath | 2005-11-14 16:15:15 | Re: Fuzzy text search |
Previous Message | jennyw | 2005-11-14 15:46:51 | Fuzzy text search |