Custom proximity search, a new feature in SQL Server 2012 Full-Text Search, is facilitated using the NEAR operator.

So you can search on "Donald*", but not "*Donald".<BR><BR>Which is a bit irritating as otherwise it'd be perfect for me.<BR><BR>So at the moment I'm thinking maybe some combination of full-text ...

A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or cloud-hosted AI models without relying on massive general-purpose LLMs.