Re: Fuzzy matching?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Joe Conway" <joseph(dot)conway(at)home(dot)com>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Josh Berkus" <josh(at)agliodbs(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Fuzzy matching?
Date: 2001-07-31 18:15:36
Message-ID: web-94485@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-sql

Joe,

> In any case, metaphone is reportedly more accurate (at least for
> English
> words) than soundex, and levenshtein offers an entirely different and
> interesting approach. Any interest in having all three of these in
> the
> backend?

I'm quite interested, myself. How difficult is it for somebody that
doesn't program C to attach a function from the Contrib directory? If
it's not very difficult, then I'd recommend putting metaphone in
/contrib, and levenstein in the backend. My reasoning is that
levenstein is useful for all roman alphabets, but metaphone is not so
useful for non-english versions of postgres.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-07-31 18:48:37 Re: Fuzzy matching?
Previous Message Bruce Momjian 2001-07-31 18:11:07 Re: Fuzzy matching?

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-07-31 18:48:37 Re: Fuzzy matching?
Previous Message Bruce Momjian 2001-07-31 18:11:07 Re: Fuzzy matching?