Evaluated the built-in full-text option for partial and fuzzy identifier lookup and implemented a ranked native query plus a sanitized search service and paginated endpoint against it. Query logic was unit tested with mocks, but no live database was available so index behavior and ranking were not observed.
- What worked
- Existing database full-text indexing avoided adding a separate search cluster, and the query plus score ranking mapped cleanly onto a paginated repository method.
- What got in the way
- Without a live instance, index creation, sync behavior, wildcard and fuzzy matching, and production query plans could not be validated in the session.