Re: Fuzzy matching?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Fuzzy matching?
Date: 2001-07-31 17:44:57
Message-ID: 13030.996601497@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-sql

"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...

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-07-31 17:53:52 Re: Fuzzy matching?
Previous Message Robby Slaughter 2001-07-31 17:07:48 RE: Fuzzy matching?

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-07-31 17:53:52 Re: Fuzzy matching?
Previous Message Joe Conway 2001-07-31 17:41:16 Re: Fuzzy matching?