Andrew,

Did you test SOUNDEX() function on a 2.5 million records? I need a very fast phoentic search algorithm in order to achieve my requirement.