Working with Text Search

1. Creating Text Index

Form	Effect
`createIndex({title:"text", body:"text"})`	Multi-field text index
Limit	One text index per collection

Operator	Form
$text	`find({$text: {$search: "terms"}})`
Default	Match any term (OR)
Score	`{score: {$meta: "textScore"}}` in projection

db.articles.find(
  { $text: { $search: "mongodb performance" } },
  { score: { $meta: "textScore" } }
).sort({ score: { $meta: "textScore" } });

Pattern	Effect
"exact phrase"	Quoted = exact phrase match
term1 "phrase"	Mix terms + phrases

Pattern	Effect
term -unwanted	Prefix `-` to exclude
Whole word	Exclusion is per word, not substring

Form	Effect
`{$search: "x", $language: "spanish"}`	Per-query language
"none"	Disable stemming/stop-words

Aspect	Detail
Score range	Unbounded positive (term freq + field weight)
Required projection	Include score field for sort

Option	Effect
$caseSensitive: true	Match case exactly (default false)
Performance	Slightly slower

Option	Effect
$diacriticSensitive: true	café ≠ cafe (default false)
Default	Accent-insensitive in text v3 (4.0+)

Pattern	Effect
`{$text:{$search:"x"}, status:"published"}`	Text + scalar filter
Compound text index	Add equality prefix for selectivity: `{tenantId:1, title:"text"}`

Limitation	Detail
One per collection	Cannot have multiple text indexes
No partial matching	Whole-word stem only
No fuzzy / typo tolerance	Use Atlas Search
Sort limit	Cannot sort by other fields alongside text score easily

Aspect	Detail
Form	$match with $text must be FIRST stage
Score field	Use `{$meta: "textScore"}` in $project or $addFields