The index-based search returns results for substrings only if they are at the beginning of a word (see table).
It is expected that the index search will also yield results if the search string is within a word. Analogous to the SQL search with like '%…