Playing with the SOUNDEX function

Hi All

Have you ever tried the SOUNDEX function for finding phonetically similar words such as querying First Name you vaguely remeber.I read about this in Alex's Siebel Essentials and after a bit of trial/POC I am writing this post.

So I typed in this query and ....

 








got the following results

so here we can see that the soundex value for all the results are same.

The Soundex algorithm is as follows:

1.The soundex return value will always begin with the first letter of string.'P' in our case.

2.The soundex function uses only the first 5 consonants to determine the NUMERIC portion of the return value, except if the first letter of string is a vowel.

3.The soundex function is not case-sensitive. What this means is that both uppercase and lowercase characters will generate the same soundex return value.

Applies to :Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

Have a nice day ahead.....