fuzzy search

From: giuseppe(dot)derossi(at)email(dot)it
To: pgsql-admin(at)postgresql(dot)org
Subject: fuzzy search
Date: 2008-08-02 10:48:11
Message-ID: eee12216ba96084ec138f1b3da83a1f7@87.11.84.115
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message C K 2008-08-02 10:58:29 functions
Previous Message Mathias Stjernström 2008-08-02 10:39:19 Re: Nls sorting in Postgresql-8.3.3