Build smarter search without AI: Fuzzy matching for applications | Data Exposed @MicrosoftDeveloper
Build smarter search without AI: Fuzzy matching for applications | Data Exposed  @MicrosoftDeveloper
Uploaded November 2026 | Updated November 2026, 15 hours ago
Not every search problem requires AI, embeddings, or vector databases.

Most business applications simply need to handle real-world data imperfections: misspelled customer names, inconsistent product descriptions, duplicate records, incomplete entries, and user input that rarely matches stored data exactly. Traditional string-matching techniques such as LIKE, CHARINDEX, PATINDEX, Full-Text Search, and even Regular Expressions solve many search scenarios, but they often struggle when the data itself is imperfect.

In this session, we'll explore the newest fuzzy string-matching capabilities in Azure SQL and SQL Server and see where they fit within the broader SQL search ecosystem. Through practical demonstrations, we'll compare fuzzy matching against existing approaches including LIKE predicates, Full-Text Search, and Regular Expressions, helping you understand the strengths, limitations, and ideal use cases for each technique.

Using real-world scenarios such as customer lookup, product search, duplicate detection, master data management, data cleansing, and application search experiences, you'll learn how to build typo-tolerant and user-friendly applications without introducing unnecessary AI complexity.

βœ… Let's connect:
LinkedIn - Anna Hoffman, linkedin.com/in/amthomas46
Twitter - AzureSQL, https://aka.ms/azuresqltw
LinkedIn - Abhiman Tiwari, linkedin.com/in/abhiman-tiwari

πŸ”΄ Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt

πŸ”” Subscribe to our channels for even more SQL tips:

Microsoft SQL / Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt


#AzureSQL #SQL #LearnSQL
Build smarter search without AI: Fuzzy matching for applications | Data ExposedShip an AI agent without leaving your terminalWhats new in AI?Build an AI agent without leaving VS CodeState of MCPWhats the deal with these IQs?Microsoft Quantum Development Kit (QDK)Event-driven agents, powered by MCPShield sensitive fields with Dynamic Data Masking for Microsoft SQL | Data Exposed MVP EditionArmchair Architects: Enterprise Security and Governance (pt 2)When the Experts on VacationEvaluating AI Models with Microsoft Foundry | MVP Unplugged
Microsoft Developer |

Build smarter search without AI: Fuzzy matching for applications | Data Exposed

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER