SQL Close Match

[POB]

I'm trying to find a function that can return a close match in SQL.

For example if a user enters Llondon the search should return London as an option.

Closest type of concept would be a spell checker.

I have experimented with the Soundex function, but its not sutible for correcting input errors in this way.

Any ideas?

 

[POB]

Thanks for the input.

I'm currently downloading the full text search add in for MSSQL to see if that has anything usefull in it.