SQLite with FTS5 (full-text search with porter stemming)

A high-performance virtual table module for SQLite that enables lightning-fast full-text indexing and Porter stemming for linguistic normalization.

SQLite with FTS5 transforms standard database files into powerful search engines by indexing text across multiple columns for sub-millisecond retrieval. The integrated Porter Stemming algorithm reduces words to their root forms (e.g., 'searching' and 'searched' both map to 'search'), ensuring users find relevant results regardless of suffix. This extension supports advanced features like BM25 ranking, proximity queries, and custom tokenizers while maintaining the zero-configuration, single-file portability that defines the SQLite ecosystem.

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