Use the trigram tokenizer: https://www.sqlite.org/fts5.html#the_trigram_tokenizer

I have found this as well, FTSE5 is convenient to have as an option, but it's not as versatile as postgres or sonic or other full-text search solutions.

Does anyone have any other favorite modern bloom-filter-based search solutions that dont need to store copies of all the documents in the search db? Ideally something that can run in WASM too so we can ship a tiny search index to the browser. I found https://github.com/tinysearch/tinysearch but haven't tried it yet.

Doesn't this work ok?

https://www.sqlite.org/fts5.html#fts5_prefix_queries