Yes, fuzzy logic works almost as well as "soundex" indices in most cases. I read about real world examples that shows that.
In english, the benefit of "soundex" indices is not too small however, since the same sound can be spelled in so many different ways. "f" as 'f' or 'gh' etc.
There are ready implementations in oracle and maybee other expensive databases, but which are some work to "tune".
To implement a "soundex" index yourself is suicide. It is far more complex to do it well than you can possible imagine.
Gil
> To implement a "soundex" index yourself is suicide.
> It is far more complex to do it well than you can
> possible imagine.
Nonsense. It's quite simple. 5 steps:
http://en.wikipedia.org/wiki/Soundex
Contains a list of improvements to the algorithm:
http://www.creativyst.com/Doc/Articles/SoundEx1/SoundEx1.htm
There's also the metaphone which is more complex but still not hard to understand:
http://en.wikipedia.org/wiki/Metaphone