Doesn't this work ok?

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