The text index and corresponding query options should be capable of "starts with" "ends with" and "contains" as well as case sensitive or insensitive search.