Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email helpdesk@pass.org. Thank you for your patience.

Details

Fuzzy-String Searching: UDF and CTE performance

Tom Keller
60 minutes
Intermediate
SQL Dev Track
How do you find information that was saved misspelled, or when your search is misspelled? Fuzzy-string processing! And if your information is in a database, the best place to do that processing is in the database. But there are some performance lessons to learn along the way. This session graphically illustrates the Damerau-Levenshtein Distance algorithm, and explains how it was optimized for T-SQL, using www.fuzzy-string.com and Confio Ignite.

Back to Top cage-aids
cage-aids
cage-aids
cage-aids