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 “iterations” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
iterations1041382(None) 
iteration9515031iteration_
literations11610581literations
aerations9317902_aerations
alterations11511662alterations
ideations1039902ide_ations
integrations13129472integrations
interactions14410462interactions
iterating10314252iterati_ng
itinerations1245682itinerations
liberations1358942liberations
literation10511412literation_
nitrations10312032nit_rations
operations12312952operations
reiterations12410872reiterations
titrations1039172titrations
aberrations1346693aberrations
adorations11310233adorations
aeration8319933_aeration_
alliterations1384553alliterations
alteration10612903alteration_
altercations1446373altercations
alternations1246773alternations
attractions1376403attractions
attritions1066793attritions
botherations1754193botherations
catenations1348363catenations
ceratins102818733_cerati_ns
chelations1539073chelations
citations11312503cit__ations
creations112614543cre_ations
cremations14410713cremations
crenations12511693crenations
deaerations12311673deaerations
delations102616593_delations
detractions14118273detractions
detritions1148953detritions
deuterations1348083deuterations
durations10311463_durations
elations83719123__elations
elevations1338633elevations
enations83316903__enations
enervations1478573enervations
erasions8310983__erasions
execrations2048923execrations
exertions1639763exer_tions
federations1548883federations
fetations12511383_fetations
figurations1545083figurations
filtrations1445623filtrations
gelations102513093_gelations
generations12311423generations
gyrations1336923_gyrations
hibernations1744053hibernations
hydrations1745283hydrations
ideation9310493ide_ation_
illations9311393i_llations
imitations1259963imitations
impetrations1645443impetrations
incretions1248653incretions
indexations1946023indexations
indurations1249583indurations
inebriations1456323inebriations
inflations13310323inflations
infractions1646963infractions
innervations1546923innervations
insertions10410343inser_tions
integration121310493integration_
intenerations1347463intenerations
intentions10411403inte_ntions
interaction13411813interaction_
intimations13411883intimations
intonations1149523intonations
intubations1346833intubations
iodations1039113i_odations
isolations10310693isolations
itemizations2347843itemizations
iterates81317823iterat__es
iterative12410713iterati_ve
itineration1156323itineration_
keratins122313483_kerati_ns
lacerations1348333lacerations
legations102711923_legations
liberation1269993liberation_
librations12149063librations
lineations1039543line_ations
literators1048103literat_ors
litigations1247333litigations
macerations1548473macerations
maturations1348443maturations
migrations13168683migrations
mitigations1447623mitigations
moderations1448273moderations
narrations1038943narrations
negations102811963_negations
nervations1359483_nervations
nitration9313443nit_ration_
numerations13127293numerations
obliterations1553453obliterations
obturations13116423obturations
operation11314003operation_
orations81515803__orations
overactions1648213overactions
predations13812153predations
prorations12314463prorations
rations74123433___rations
reiteration11412163reiteration_
relations92418333_relations
retractions13910353retractions
saturations1148573saturations
sedations10311253_sedations
seriations10316683_seriations
serrations10313093serrations
situations1038433sit_uations
starvations1445053starvations
stations82415223st__ations
steradians1143883steradians
striations10312793striations
tarnations1038903_tarnations
taxations1636863_taxations
teratisms11410073_teratisms
ternions838813_ter_nions
tertians839103_ter_tians
tevatrons1244003_tevatrons
titivations1446263titivations
titration9310543titration_
tolerations1158133tolerations
tractions11511623_t_ractions
triturations1245683triturations
ulcerations1346363ulcerations
venations12311723_venations
venerations14411313venerations
vernations13310333_vernations
vexations1937753_vexations
vibrations15157373vibrations
vitiations1338743vit_iations
vituperations1852313vituperations

Search took 8 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 Filter1786911406030.563317390.8
2DLD Change Limit1406031376.93620271.5
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.56223630.1
 
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.