I have an application in which SoundEx algorithm is implemented. Now i want to test the functionality.
Here is what i observe In my database i have 2 names Breaks and Brakes. Assume these are names of 2 employees of a company. Now i am searching for the name giving Break as search criteria and now this returns me the 2 results breaks and brakes which is right as per Soundex
Now in the search criteria i give Brakes as filter and i am expecting both the records to be returned. However i am getting only Brakes record.
Is there something i am missing or is my understanding wrong.