Templar, Simon
2020-10-30T22:47:00Z
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.
Administrator
2020-10-31T09:02:00Z
this is not related to GeniusConnect Synchronization, please try Microsoft SQL Server support or many SQL Server support forums,
https://www.sqlservercentral.com/