Received: from frosch.all.de (frosch.intern [195.35.6.2] (may be forged)) by hub.org (8.8.8/8.7.5) with ESMTP id OAA22624 for ; Mon, 1 Jun 1998 14:30:17 -0400 (EDT) Received: from bolzen.denic.net (root@bolzen.in-berlin.de [194.94.235.1]) by frosch.all.de (8.8.7/8.8.7) with ESMTP id UAA20283 for ; Mon, 1 Jun 1998 20:30:14 +0200 (CEST) (envelope-from laokoon.IN-Berlin.DE!guenther@bolzen.denic.net) Received: by bolzen.denic.net (Smail3.2) id ; Mon, 1 Jun 1998 16:20:58 +0200 (MET DST) Received: (from guenther@localhost) by laokoon.IN-Berlin.DE (8.8.6/8.8.5) id UAA26692 for PGSQL-SQL@postgresql.org; Mon, 1 Jun 1998 20:02:57 +0200 Message-Id: <199806011802.UAA26692@laokoon.IN-Berlin.DE> Subject: soundex more or less exact To: PGSQL-SQL@postgresql.org Date: Mon, 1 Jun 1998 20:02:56 +0200 (MET DST) X-Charset: ISO-8859-1 From: guenther@laokoon.in-berlin.de (Christian Guenther) X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi, How can I make the soundex-function more or less exact finding results. If I have a name 'Fretwurst' and search for 'Vretwurst' I do not get the 'Fretwurst' as result. Is it possible to get it right, because for me Vretwurst is near by Fretwurst? Sorry about the terrible English. Thanks for any hints Christian Guenther -- Christian Guenther http://laokoon.in-berlin.de/Kuenstler/ Fax: +49 030 4464152 http://laokoon.in-berlin.de/Museum/ Tel: +49 030 4442931 E-mail: guenther@laokoon.in-berlin.de