I know this must be possible but can't find an answer on the web, in my SQL Server book or help files.
Basically, I have a permuted index of terms and want to find the nearest alphabetic match. For instance, on a search for 'Answer' I'd want the first result to be something like 'Ansing' as opposed to sorting ascending or decending by column. If it's possible to get the single nearest match even better.
I already have a full-text index on the relevant column if that helps.
Any ideas gratefully received...
Basically, I have a permuted index of terms and want to find the nearest alphabetic match. For instance, on a search for 'Answer' I'd want the first result to be something like 'Ansing' as opposed to sorting ascending or decending by column. If it's possible to get the single nearest match even better.
I already have a full-text index on the relevant column if that helps.
Any ideas gratefully received...
