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
alterations11511652alterations
ideations1039902ide_ations
integrations13129472integrations
interactions14410452interactions
iterating10314252iterati_ng
itinerations1245682itinerations
liberations1358942liberations
literation10511412literation_
nitrations10312032nit_rations
operations12312932operations
reiterations12410852reiterations
titrations1039172titrations
aberrations1346683aberrations
adorations11310223adorations
aeration8319933_aeration_
alliterations1384543alliterations
alteration10612903alteration_
altercations1446363altercations
alternations1246773alternations
attractions1376393attractions
attritions1066793attritions
botherations1754163botherations
catenations1348363catenations
ceratins102818723_cerati_ns
chelations1539073chelations
citations11312493cit__ations
creations112614533cre_ations
cremations14410703cremations
crenations12511683crenations
deaerations12311663deaerations
delations102616593_delations
detractions14118263detractions
detritions1148953detritions
deuterations1348073deuterations
durations10311463_durations
elations83719123__elations
elevations1338633elevations
enations83316903__enations
enervations1478573enervations
erasions8310983__erasions
execrations2048903execrations
exertions1639763exer_tions
federations1548863federations
fetations12511383_fetations
figurations1545073figurations
filtrations1445623filtrations
gelations102513093_gelations
generations12311403generations
gyrations1336923_gyrations
hibernations1744053hibernations
hydrations1745273hydrations
ideation9310493ide_ation_
illations9311393i_llations
imitations1259963imitations
impetrations1645443impetrations
incretions1248653incretions
indexations1946023indexations
indurations1249583indurations
inebriations1456323inebriations
inflations13310323inflations
infractions1646963infractions
innervations1546923innervations
insertions10410333inser_tions
integration121310493integration_
intenerations1347453intenerations
intentions10411403inte_ntions
interaction13411813interaction_
intimations13411883intimations
intonations1149523intonations
intubations1346833intubations
iodations1039113i_odations
isolations10310693isolations
itemizations2347823itemizations
iterates81317813iterat__es
iterative12410713iterati_ve
itineration1156323itineration_
keratins122313473_kerati_ns
lacerations1348323lacerations
legations102711923_legations
liberation1269993liberation_
librations12149063librations
lineations1039543line_ations
literators1048103literat_ors
litigations1247333litigations
macerations1548453macerations
maturations1348433maturations
migrations13168673migrations
mitigations1447623mitigations
moderations1448253moderations
narrations1038933narrations
negations102811963_negations
nervations1359483_nervations
nitration9313443nit_ration_
numerations13127283numerations
obliterations1553433obliterations
obturations13116423obturations
operation11313993operation_
orations81515793__orations
overactions1648183overactions
predations13812143predations
prorations12314433prorations
rations74123433___rations
reiteration11412163reiteration_
relations92418333_relations
retractions13910343retractions
saturations1148573saturations
sedations10311253_sedations
seriations10316683_seriations
serrations10313053serrations
situations1038423sit_uations
starvations1445053starvations
stations82415213st__ations
steradians1143883steradians
striations10312783striations
tarnations1038903_tarnations
taxations1636863_taxations
teratisms11410063_teratisms
ternions838813_ter_nions
tertians839103_ter_tians
tevatrons1244003_tevatrons
titivations1446263titivations
titration9310543titration_
tolerations1158113tolerations
tractions11511613_t_ractions
triturations1245683triturations
ulcerations1346353ulcerations
venations12311723_venations
venerations14411283venerations
vernations13310323_vernations
vexations1937753_vexations
vibrations15157373vibrations
vitiations1338743vit_iations
vituperations1852303vituperations

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.1531167915.0
2DLD Change Limit1406031377.28319305.6
3Display Results1371370.0761802.6
 (SQL Overall)1786911377.51223787.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.