Take a look at http://ntz-develop.blogspot.co.uk/2011/03/phonetic-algorithms.html

The Rolls Royce solution is Metaphone3 which I believe is in the latest Apache SOLR.

I had planned a followup article based on the link above. Ultimately the reason I looked at these functions was to experiment with beefing up the search capabiliity of SQL Server.

Yes, I could export the data to Apache SOLR but there are various reasons why I wouldn't do this.