In the project I work we have the necessity to use some kind of fuzzy search to fill an autocomplete field. This autocomplete field must show some information as the user type inside.
I'm using Azure SQL database, and I found out that it's not possible to use Master Data Services. (https://learn.microsoft.com/en-us/sql/master-data-services/master-data-services-installation-and-configuration?view=sql-server-2017)
I've already googled some solutions, and I've found something related to Levenstein fuzzy search, but the implementations I've found did not fit well in my scenario.
I'm very newbie at fuzzy searches, plz, could you suggest any actual implementation of fuzzy search in T-SQL.
You can use this documentation for step-by-step instructions on how to connect to and index an Azure SQL Database content using Azure Search indexers.
After that you can use Azure Search API to perform a fuzzy search.
https://{yourSite}.search.windows.net/indexes/{yourIndex}/docs?search={fieldToSearch}:{lookupValue}~&queryType=Full?api-version=2015-02-28&suggesterName=default&queryType=full&search=California~
You need to specify querytype=full and the tilde after the character/word that you want to execute fuzzy searches on.