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 “alliteration” 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.

86 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
alliteration128516(None) 
alliterations1384551alliterations
alliterating1354272alliterating
alliterative1553872alliterative
alteration10612902a_l_teration
literation10511412__literation
obliteration1453892obliteration
adulteration1353663adulteration
alienation1048793a_li_enation
allegation1146813all__egation
alliterate1086623alliterat__e
alliterated1294693alliterat_ed
alliterates11106253alliterat_es
alterations11511663a_l_terations
altercation1347013a_l_tercation
alternation1147623a_l_ternation
arbitration1346473arbit_ration
deliberation1546363deliberation
iteration9515033___iteration
liberation1269993__liberation
literations11610583__literations
obliterations1553453obliterations
reiteration11412163_reiteration
acceleration1654814acceleration
admiration1347734admi__ration
adulterations1453174adulterations
aeration8319934a____eration
agglomeration1762084agglomeration
agitation10311224a_git__ation
alienations1147884a_li_enations
alimentation14105334a_limentation
aliteracies1355364a_literacies
aliterate91611334a_literat__e
aliterates101510754a_literat_es
allegations1246044all__egations
alleviation1454654all_eviation
alliteratively2062044alliteratively
allocation1248574all__ocation
altercations1446374a_l_tercations
alternations1246774a_l_ternations
amelioration1464004ameli_oration
arbitrations1445764arbit_rations
aspiration1249994aspi__ration
asseveration1552894asseveration
calibration1545994cali_bration
deliberations1645534deliberations
delineation1247764deline_ation
desideration1456394desideration
deuteration1249104_deuteration
exenteration1955294exenteration
filtration1346434fil_t_ration
gallicization2574034gallicization
illiteracies1453304illiteracies
illiterate10125894illiterat__e
illiterately1552304illiterately
illiterates11115654illiterat_es
illustration1253514illustration
incineration1446294incineration
iterations10413824___iterations
itineration1156324_itineration
laceration1249574__laceration
liberations1358944__liberations
libration111510164__li_bration
lineation9310764__line_ation
literati81210804__literati__
literatim11127184__literati_m
literator948684__literat_or
litigation1148174__litigation
lustration1048354_lust_ration
melioration1368184meli_oration
nitration9313444__nit_ration
obliterating1553394obliterating
obliterative1753054obliterative
obliterator1352784obliterat_or
palletization2495194palletization
palliation1248504palli___ation
palpitation1546244palpit__ation
proliferation1853034proliferation
reiterations12410874_reiterations
scatteration1452924scatteration
titration9310544__tit_ration
toleration1048964tol__eration
transliteration1562124transliteration
trituration1146654_trituration
ulceration1247264_ul_ceration
vociferation2053184vociferation

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790867.39016886.3
3Display Results86860.0631365.1
 (SQL Overall)178691867.59323533.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.