Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6VHkLf67438 for ; Tue, 31 Jul 2001 13:46:21 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f6VHivC13033; Tue, 31 Jul 2001 13:44:57 -0400 (EDT) To: "Josh Berkus" cc: pgsql-sql@postgresql.org Subject: Re: Fuzzy matching? In-reply-to: References: Comments: In-reply-to "Josh Berkus" message dated "Tue, 31 Jul 2001 09:05:28 -0700" Date: Tue, 31 Jul 2001 13:44:57 -0400 Message-ID: <13030.996601497@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200107/394 X-Sequence-Number: 4208 "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... regards, tom lane