History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL

Fuzzy-string Searches (up to 100 most recent) for "plunder'"

Num	Started At (CA time)	Searched Word	Change Limit	Words Checked	Words Matched	Seconds	Words Per Sec
6	2026-02-23 21:26:42	plunder'	2	121059	12	3.173	38152.9
5	2026-02-23 18:02:32	plunder'	1	82945	2	1.436	57761.1
4	2026-02-21 19:07:35	plunder'	3	146162	124	15.873	9208.2
3	2026-01-24 13:11:02	plunder'	3	146162	124	7.910	18478.1
2	2025-05-21 07:47:39	plunder'	2	121059	12	3.186	37997.2
1	2023-05-20 14:16:18	plunder'	1	82945	2	1.266	65517.4

Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral | Developed By: Tom Keller Consulting © 2011-2026 | Published At: SQLServerCentral (with Source Code) | Presented At: SQLSaturday #144 | Demonstrated For: Sacramento SQL Server User Group | Developed For: Repo Remarketing | Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard) | SQL Performance Monitoring By: Confio Ignite | American Scrabble® Dictionary From: Internet Scrabble Club | Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.