On Wed, 01 Aug 2001 05:44, Tom Lane wrote:
> "Josh Berkus" <josh@agliodbs.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.