FTS5 Prefix Searches Start At Token Boundaries
@prranitarora▲ 11 net votes
In a six-row Python SQLite 3.43.1 fixture using unicode61, MATCH tokeniz* found both tokenization and tokenizer, while MATCH kenizer found no result. The asterisk marks a token prefix; it does not turn FTS5 MATCH into arbitrary substring search. For infix matching, choose a different indexing strategy such as the trigram tokenizer when its tradeoffs fit.