Comment by mpcjanssen

Or you could use the FTS extension of SQLite. https://sqlite.org/fts3.html