Received: from deborah.paradise.net.nz (deborah.paradise.net.nz [203.96.152.32]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6VLW5f43377 for ; Tue, 31 Jul 2001 17:32:05 -0400 (EDT) (envelope-from csawtell@paradise.net.nz) Received: from there (202-0-37-152.cable.paradise.net.nz [202.0.37.152]) by deborah.paradise.net.nz (Postfix) with SMTP id E6A741F9F1B; Wed, 1 Aug 2001 09:31:57 +1200 (NZST) Content-Type: text/plain; charset="us-ascii" From: Christopher Sawtell To: Tom Lane , "Josh Berkus" Subject: Re: Fuzzy matching? Date: Wed, 1 Aug 2001 09:31:51 +1200 X-Mailer: KMail [version 1.2.3] Cc: pgsql-sql@postgresql.org References: <13030.996601497@sss.pgh.pa.us> In-Reply-To: <13030.996601497@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20010731213157.E6A741F9F1B@deborah.paradise.net.nz> X-Archive-Number: 200107/400 X-Sequence-Number: 4219 On Wed, 01 Aug 2001 05:44, Tom Lane wrote: > "Josh Berkus" writes: > > For many of my programs, it would be extremely useful to have some form > > of "fuzzy matching" for VARCHAR fields. There are two kinds of fuzzy > > matching for words that I know of: > > > > 1. Phonetic matching, which would be nice but will have to wait for > > someone's $100,000 project; > > Uh, have you looked at contrib/soundex? The Soundex code is kinda > specialized but might be just what you want... Be aware that Soundex simply does not work at all well on names of Pacific origin. Samoan in particular is a total no no.