Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DF91A650279 for ; Sat, 2 Aug 2008 07:48:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 38295-04 for ; Sat, 2 Aug 2008 07:48:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-out01.email.it (smtp-out01.email.it [212.97.34.21]) by postgresql.org (Postfix) with ESMTP id 4A08F65027B for ; Sat, 2 Aug 2008 07:48:14 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-out01.email.it (Postfix) with ESMTP id 86B6B4025 for ; Sat, 2 Aug 2008 12:48:11 +0200 (CEST) Received: from smtp-out01.email.it ([127.0.0.1]) by localhost (smtp-out01.email.it [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 5m6zZUESE1iW for ; Sat, 2 Aug 2008 12:48:11 +0200 (CEST) Received: from 87.11.84.115 (wm5.email.it [212.97.34.48]) by smtp-out01.email.it (Postfix) with ESMTP id 59A7E4022 for ; Sat, 2 Aug 2008 12:48:11 +0200 (CEST) Received: from Email-mailer ([87.11.84.115]) by 87.11.84.115 with HTTP (Wmail); Sat, 2 Aug 2008 12:48:11 +0200 Date: Sat, 2 Aug 2008 12:48:11 +0200 To: pgsql-admin@postgresql.org From: giuseppe.derossi@email.it Reply-to: giuseppe.derossi@email.it Subject: fuzzy search Message-ID: X-Priority: X-Mailer: Webmail-Email.it [Mailer version 1.70] X-SenderIP: 87.11.84.115 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200808/5 X-Sequence-Number: 29850 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