Re: Fuzzy matching? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Fuzzy matching?
Date
Msg-id 13030.996601497@sss.pgh.pa.us
Whole thread Raw
In response to Fuzzy matching?  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: Fuzzy matching?  (Christopher Sawtell <csawtell@paradise.net.nz>)
List pgsql-sql
"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


pgsql-sql by date:

Previous
From: "Robby Slaughter"
Date:
Subject: RE: Fuzzy matching?
Next
From: "Joe Conway"
Date:
Subject: Re: Fuzzy matching?