Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “agonizingly” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

40 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
agonizingly256162(None) 
agonizing2047142agonizing__
agenizing2046333agenizing__
agnizing1936833ag_nizing__
agonising1146573agonising__
atoningly1365373aton__ingly
patronizingly286963patronizingly
abidingly1644554a__bidingly
admiringly1742854a_dmiringly
admonishingly238774admonishingly
adoringly1445424ado__ringly
agatizing2087474agatizing__
amazingly2444144a__mazingly
annoyingly1742364a_nnoyingly
anodizing2046874anodizing__
appetizingly2981244appetizingly
astonishingly206994astonishingly
atomizing2148514atomizing__
azotizing1846014azotizing__
boilingly1545914_bo_ilingly
canonizing2247714canonizing__
caponizing2446984caponizing__
cognizing2247174cognizing__
confidingly2153184_confidingly
droningly1445764dron__ingly
ebonizing2146824ebonizing__
gibingly1534794_g__ibingly
gnawingly1763934_g_nawingly
grazingly2344944_g_razingly
grindingly1643754_grindingly
grinningly1543374_grinningly
ionizing1839504_ionizing__
ironizing1947934ironizing__
jargonizing2944194jargonizing__
lionizing1947054lionizing__
longingly1445334_lon_gingly
moilingly1545844_mo_ilingly
ozonizing1845294ozonizing__
paganizing2347274paganizing__
promisingly1953004promisingly

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.436409841.7
2DLD Change Limit148819408.42317668.2
3Display Results40400.0162500.0
 (SQL Overall)178691408.87520134.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.