MSSQL v 2012
Have a table called dictionary with 2 fields: words, SortedWord
words - have about 138K words, SortedWord is those words sorted alphabetically.
When trying to run this select statement, I get only 14 results when I should get a lot more
Any idea?
select * from dictionary where charindex(SortedWord, 'deelovv') > 0
in the above example i'm not getting the word devel for eg. and many others.