natuleadan Full-Text Search
Overview
Full-text search with LanceDB using BM25 indexing. Covers FTS index creation, query patterns, fuzzy search, and advanced filtering.
Quick Reference
FTS Index
table.create_fts_index("text_column", replace=True)
Basic Query
const results = await table.search("search terms", queryType="fts").toArray()
FTS Features
| Feature | API | Description |
|---|---|---|
| Phrase | "exact phrase" |
Exact phrase matching |
| Fuzzy | term~1 |
Levenshtein distance |
| Field boost | field:term^2 |
Weighted field scoring |
| Boolean | Must/Should | AND/OR term combinations |
| Filtering | .filter(sql) |
Metadata pre-filtering |
References
- FTS Index — Index creation, BM25 configuration, tokenization
- FTS Querying — Query patterns, phrase search, index usage
- FTS Advanced — Fuzzy, boosting, boolean, array fields, filtering