Re: Fuzzy matching?

From: Christopher Sawtell <csawtell(at)paradise(dot)net(dot)nz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Fuzzy matching?
Date: 2001-07-31 21:31:51
Message-ID: 20010731213157.E6A741F9F1B@deborah.paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-sql

On Wed, 01 Aug 2001 05:44, Tom Lane wrote:
> "Josh Berkus" <josh(at)agliodbs(dot)com> writes:
> > For many of my programs, it would be extremely useful to have some form
> > of "fuzzy matching" for VARCHAR fields. There are two kinds of fuzzy
> > matching for words that I know of:
> >
> > 1. Phonetic matching, which would be nice but will have to wait for
> > someone's $100,000 project;
>
> Uh, have you looked at contrib/soundex? The Soundex code is kinda
> specialized but might be just what you want...

Be aware that Soundex simply does not work at all well on names of Pacific
origin. Samoan in particular is a total no no.

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-07-31 21:51:45 Re: Revised Patch to allow multiple table locks in "Unison"
Previous Message Josh Berkus 2001-07-31 20:53:37 Re: Fuzzy matching?

Browse pgsql-sql by date

  From Date Subject
Next Message Timothy H. Keitt 2001-08-01 02:27:17 Re: Fuzzy matching?
Previous Message Josh Berkus 2001-07-31 20:53:37 Re: Fuzzy matching?