Full search does not match word prefixes: node misses node1

[vitorcsbrito]

Version: 3.1.1 with PostgreSQL 18. The same query code is on the current scarlett branch.

What Happens

The full search on /_search only matches whole words. A page whose body contains node1 and node2 is found by searching node1, but searching node does not find it.

The suggestions under the header search box do match substrings, but only on titles and paths, so they do not help with body text.

What I Expected

Searching node should surface pages that contain node1 and node2. Names with numeric suffixes are common in documentation, for example hosts and environments, so the shared prefix is often the natural thing to type.

Cause

backend/models/search.ts builds the query with websearch_to_tsquery, which matches complete lexemes and has no way to express a prefix.

Possible Fix

PostgreSQL supports prefix matching in a tsquery, so to_tsquery('english', 'node:*') matches both node1 and node2. The search could add :* to unquoted terms while keeping the current quoted phrase, OR and - syntax, or offer this as an option under Admin → Search.

Related 2.x report: #3897

[NGPixel]

Fixed via 6b72ee7. Will land in next release.