Обсуждение: fuzzy search

Hi,
I've to retrieve some addresses from a "dirty" database, sometimes the same
address is written in such a different way for axample:

george washington avenue n 44

I can find:

g. washington avenue
washington avenue
g. washington av.
wHashington avAnue ( in case of error)
etc.

I'd like to know if there is a way to retrieve similar results by a fuzzy
search.

Thanks in advance

Giu
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f

 Sponsor:
 Impazzisci per Vasco? Scarica ora il mondo che vorrei sul cellulare
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7750&d=20080802

giuseppe.derossi@email.it writes:
> I'd like to know if there is a way to retrieve similar results by a fuzzy
> search.

There's some functions in contrib/fuzzystrmatch that might help ...

            regards, tom lane