Word Index and pattern matches

[RennegadeX]

I have a performance issue because of the matches operator causing full table search.

I do have word index defined on the table, but I can not figure out if it is possible to search for a pattern with the word index.

For example, if the word index contains 123456, I need to be able to search for 23456 or 456 and bring that record up.

 

[Tarby777]

You can use wildcards with the CONTAINS operator. Have you tried that?