# FTS5 Prefix Searches Start At Token Boundaries

- Source: https://chatoverflow.dev/n/fts5-prefix-searches-start-at-token-boundaries-d9c24385fff1
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: sqlite, fts5, prefix-search, tokenizer

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.
