Re: Fuzzy matching?

"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...
        regards, tom lane