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 “illuviations” 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
illuviations155305(None) 
illuviation1453571illuviation_
alleviations1554492alleviations
eluviations14115792_eluviations
illuminations1554442illuminations
illuviating1552942illuviati_ng
alleviation1454653alleviation_
bloviations1643753_bloviations
eluviation1376613_eluviation_
exuviations2195693_exuviations
illations9311393ill___ations
illumination1455163illumination_
illustrations1353153illustrations
illuviates1343813illuviat__es
infuriations1547443infuriations
lixiviations2252763lixiviations
allegations1246044all_egations
alleviating1553594alleviati_ng
alleviators14103174alleviat_ors
allocations1347774all_ocations
alluvions1254374alluv___ions
aviations12311554___aviations
bloviation1544004_bloviation_
calumniations1763484calumniations
ciliations121111004cil__iations
claudications1852884claudications
clavations1546184_clav_ations
columniations1764794columniations
cultivations1745594cultivations
deviations14311164__deviations
elevations1338634_elev_ations
elucidations1544514_elucidations
elutriations1246024elutriations
eluviating1444894_eluviati_ng
exuviation20116344_exuviation_
filiations13119094fil__iations
floriations1476914_floriations
foliations1399944fol__iations
glaciations1445964_glaciations
hallucinations19112524hallucinations
illation8311944ill___ation_
illuminating1553924illuminati_ng
illuminators1453274illuminat_ors
illusions946214illu___sions
illustration1253514illustration_
illuviate1244574illuviat___e
illuviated1453124illuviat__ed
immunizations26115344immunizations
imputations1546354impu_tations
incubations1547304incu_bations
inculcations1666314inculcations
inculpations1675964inculpations
incurvations1746384incurvations
indurations1249584indu_rations
inebriations1456324inebriations
infuriation1448244infuriation_
inhumations1666034inhu_mations
initiations11410724i_nitiations
innovations1445264innov_ations
insulations11310234insu_lations
intubations1346834intu_bations
intuitions1047294intu_i_tions
inundations12125534i_nundations
invitations1449054i__nvitations
irradiations1394884irradiations
laudations1146844_lau_dations
laureations1145574_laureations
lavations1238974__lav_ations
levigations1546214__levigations
levitations1448294__levitations
liquations1945624liqu__ations
liquidations2242794liquidations
lixiviation2182954lixiviation_
lunations9310724__lu_nations
luxations1637274__lu_xations
obviations1545464__obviations
palliations1347724pal_liations
pullulations1442964pullu_lations
reluctations1446754reluctations
repudiations1597034repudiations
salivations1448734saliv_ations
salutations1147644salu_tations
salvations1338134sal_v_ations
solvations1336834sol_v_ations
ululations1037144_ulu_lations
valuations1348784valu__ations

Search took 9 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.390458182.1
2DLD Change Limit124790868.48314710.6
3Display Results86860.0461869.6
 (SQL Overall)178691868.91920034.9
 
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.