| From: | "Joe Conway" <joseph(dot)conway(at)home(dot)com> |
|---|---|
| To: | "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:06:48 |
| Message-ID: | 03d501c119eb$91c23f40$48d210ac@jecw2k1 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches pgsql-sql |
> > Sounds like you want something along the lines of soundex or metaphone?
I
> > don't see either function in PostgreSQL, but take a look at the PHP
manual
> > to see examples: http://www.php.net/manual/en/function.soundex.php ,
> > http://www.php.net/manual/en/function.metaphone.php
> >
>
> See /contrib/soundex.
Sorry, missed that -- I only looked in the Documentation :(
I guess it's not there because it is a contrib. FWIW, both Oracle and MSSQL
have a built-in soundex function.
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?
-- Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-07-31 18:11:07 | Re: Fuzzy matching? |
| Previous Message | Bruce Momjian | 2001-07-31 17:53:52 | Re: Fuzzy matching? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-07-31 18:11:07 | Re: Fuzzy matching? |
| Previous Message | Bruce Momjian | 2001-07-31 17:53:52 | Re: Fuzzy matching? |