pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Herouth Maoz <herouth@oumail.openu.ac.il>
To: guenther@laokoon.in-berlin.de
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] soundex more or less exact
Date: Tue, 2 Jun 1998 10:54:03 +0300
Message-ID: <l03110700b1995dbfd3f6@[147.233.159.109]> (raw)
In-Reply-To: <199806011802.UAA26692@laokoon.IN-Berlin.DE>

At 21:02 +0300 on 1/6/98, Christian Guenther wrote:


> 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?

Soundex is not a magic wand. It is a generic name for a function that maps
words that sound the same to one root. But "sound the same" in which
language? I once wrote a soundex function for Arabic. Believe me, it is
nothing like English soundex. It may be tempting to use English soundex for
German - after all, they use the same character set, more or less. But
since pronounciation of "V" and "F" and "W" is different, and I think
there's also some difference in "S", the way things *sound* is different.
It may not be as far as Arabic is from English, but it's enough to render
the function invalid for practical purposes.

That's the theory. In practice, I believe the soundex in PostgreSQL is a
contributed module. So if you have programming skills, you may want to
follow the sources, see how they work, and change the function to apply
German logic rather than English logic. Then you can contribute your own
version as "german_soundex" or whatever.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma





view thread (2+ messages)

Message-ID: <l03110700b1995dbfd3f6@[147.233.159.109]>
Permalink:  ../l03110700b1995dbfd3f6@%5B147.233.159.109%5D/
Also on:    postgresql.org/message-id/l03110700b1995dbfd3f6@[147.233.159.109]

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: herouth@oumail.openu.ac.il, guenther@laokoon.in-berlin.de
  Subject: Re: [SQL] soundex more or less exact
  In-Reply-To: <l03110700b1995dbfd3f6@[147.233.159.109]>
  References: <199806011802.UAA26692@laokoon.IN-Berlin.DE> <l03110700b1995dbfd3f6@[147.233.159.109]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox