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

79 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
alliterations138455(None) 
alliteration1285161alliteration_
alliterating1354272alliterati_ng
alterations11511662a_l_terations
literations11610582__literations
obliterations1553452obliterations
adulterations1453173adulterations
alienations1147883a_li_enations
allegations1246043all__egations
alliterates11106253alliterat__es
alliterative1553873alliterati_ve
alteration10612903a_l_teration_
altercations1446373a_l_tercations
alternations1246773a_l_ternations
arbitrations1445763arbit_rations
deliberations1645533deliberations
iterations10413823___iterations
liberations1358943__liberations
literation10511413__literation_
obliteration1453893obliteration_
reiterations12410873_reiterations
accelerations1754194accelerations
admirations1446694admi__rations
adulteration1353664adulteration_
aerations9317904a____erations
agglomerations1861784agglomerations
agitations11310064a_git__ations
alienation1048794a_li_enation_
alimentations1594994a_limentations
aliteracies1355364a_literaci_es
aliterates101510754a_literat__es
allegation1146814all__egation_
alleviations1554494all_eviations
alliterate1086624alliterat___e
alliterated1294694alliterat__ed
alliteratively2062044alliteratively
allocations1347774all__ocations
altercation1347014a_l_tercation_
alternation1147624a_l_ternation_
ameliorations1563194ameli_orations
arbitration1346474arbit_ration_
aspirations1348994aspi__rations
asseverations1652594asseverations
calibrations1645154cali_brations
deliberation1546364deliberation_
delineations1346764deline_ations
desiderations1545674desiderations
deuterations1348084_deuterations
exenterations2054484exenterations
filtrations1445624fil_t_rations
gallicizations2673904gallicizations
illiteracies1453304illiteraci_es
illiterates11115654illiterat__es
illustrations1353154illustrations
incinerations1545684incinerations
iteration9515034___iteration_
itinerations1245684_itinerations
lacerations1348334__lacerations
liberation1269994__liberation_
librations12149064__li_brations
lineations1039544__line_ations
literators1048104__literat_ors
litigations1247334__litigations
lustrations1147624_lust_rations
meliorations1466754meli_orations
nitrations10312034__nit_rations
obliterating1553394obliterati_ng
obliterators1452604obliterat_ors
palletizations25105014palletizations
palliations1347724palli___ations
palpitations1645524palpit__ations
proliferations1952704proliferations
reiteration11412164_reiteration_
scatterations1552544scatterations
titrations1039174__tit_rations
tolerations1158134tol__erations
triturations1245684_triturations
ulcerations1346364_ul_cerations
vociferations2153114vociferations

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 Filter178691950240.1561145455.1
2DLD Change Limit95024795.25018099.8
3Display Results79790.0461717.4
 (SQL Overall)178691795.45232775.3
 
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.