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

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

72 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
catenations134836(None) 
catenation1249521catenation_
carnations12311352ca_rnations
caseations1258302case_ations
catenating1348682catenati_ng
crenations12511692c_renations
patinations13411002patinations
activations1669263activations
actuations1239293act_uations
adnations1039753_a_dnations
aerations9317903_a_erations
agnations10310033_a_gnations
alienations1147883alienations
alterations11511663alterations
alternations1246773alternations
attentions1045983atten_tions
attenuations1243803attenuations
calcinations1647933calcinations
cancelations1657093cancelations
capitations1549853capitations
captivations1945343captivations
carbonations1644843carbonations
carnation11312943ca_rnation_
caseation1199513case_ation_
cassations1276873ca_ssations
castigations1547203castigations
castrations13410053castrations
catenaries1248663catenari_es
catenates11311813catenat__es
caudations13108223ca_udations
causations1268143ca_usations
cavitations1647843cavitations
cementations1659013cementations
chelations1539073c_helations
citations11312503cit__ations
cognations1339593c_ognations
conations111318903c__onations
concatenations1873723concatenations
connations12312943c_onnations
contentions13412093conten_tions
coronations13410703coronations
creations112614543c_re_ations
cremations14410713c_remations
crenation11412923c_renation_
cybernations1943603cybernations
damnations1337083da_mnations
darnations1138413da_rnations
detentions11148803deten_tions
detonations1239373detonations
enations83316903___enations
extenuations1945083extenuations
intentions10411403inten_tions
intonations1149523intonations
iterations10413823_iterations
lacerations1348333lacerations
lamentations1495983lamentations
laminations1339803laminations
literations11610583literations
macerations1548473macerations
marinations13411273marinations
maturations1348443maturations
natations91412493nat__ations
ostentations1246123ostentations
paginations1447753paginations
patination12312573patination_
retentions101611113reten_tions
satiations10312113sat_iations
saturations1148573saturations
scatterations1552543scatterations
stagnations1244903stagnations
tarnations1038903ta_rnations
venations12311723__venations

Search took 6 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 Filter1786911216330.686260482.5
2DLD Change Limit121633724.87624945.2
3Display Results72720.0461565.2
 (SQL Overall)178691725.60831863.6
 
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.