SOUNDEX

[Ruslan Zasukhin]

On 7/27/04 7:51 AM, "olivier" <vidal_olivier at yahoo.fr> wrote:

>> What is soundex?
> 
> It is the (simple) algorithm which allows to examine in a phonetic way.
> It is useful especially for the family names. it was invented in 1918
> for the census of American population.
> 
> He allows to examine not names themselves but their consonance.
> Very useful when there are spelling mistakes for example.
> 
> There are several variants of Soundex but the original algorithm (very
> simple) is always very used (we find easily this algorithm on
> internet).
> it is integrated, for example, into oracle or SQL server.
> 
> Eg, in French, if we look for the 'GROS' name, for soundex find:
> - GRAU
> - GROS
> - GROSS
> - GROZ
> - GRAS
> - GRASS
> 
> In Russia, I believe that it was improved by Vladimir Levenshtein.
> In France, there are variants adapted to our pronunciation (Phonex for
> example). In fact, we can easily program it there realbasic
> 
> But maybe that he it would be faster if it was integrated into
> Valentina?

I see guys,

So this affect searches?

We need way to say somehow

    WHERE name = 'GROS' using soundex

Right?

What syntax Is used in SQL Server ?


Do you have info if this can be indexed search?
Or this is always scan like "LIKE" ?




-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------