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

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

90 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
machicolations239194(None) 
machicolation22112271machicolation_
machinations19115763machi__nations
matriculations18144783matriculations
acidulations15104814_ac_idulations
articulations1546734_articulations
cachinnations2092124cachi_nnations
fasciculations21133094fasciculations
machicolated2251804machicolat__ed
machination18106824machi__nation_
maculations1569624ma___culations
manipulations1754114ma_nipulations
mastications1649414mastic__ations
matriculation17125384matriculation_
sacculations1646664sac__culations
vacillations1744874vac_i_llations
vacuolations1743774vac__uolations
abdications1657655_abdic__ations
accumulations19143625_accumulations
accusations1546005_ac__cusations
acetylations1743545_ac_etylations
acidulation14105405_ac_idulation_
activations1669265_acti__vations
acylations1547605_a___cylations
ameliorations1563195ameli_orations
annihilations1653995_annihilations
anticipations1757495_anticipations
articulation1447975_articulation_
assimilations1555205_assimilations
brachiations19193525brachi___ations
cachinnation1972425cachi_nnation_
calculations1647075__calculations
cancelations1657095__cancelations
cantillations1545735canti_llations
capitulations1754065ca_pitulations
chelations1539075__ch__elations
chocolatiers1971605__chocolatiers
circulations1648485__circulations
consolations1449745__consolations
denticulations1753915denticulations
echolocations2052625_echolocations
emaciations1548165emac_i___ations
emasculations1754605ema__sculations
etiolations1147395__eti_olations
fabrications1945925fabric__ations
facilitations1845765fac_ilitations
fasciculation20133565fasciculation_
fractionations1952865fracti_onations
gallicizations2673905gallicizations
gesticulations1784115gesticulations
isolations10310695____isolations
jactitations2145015jacti__tations
laciniations1445915lac_i_niations
lacrimations1645705lacri__mations
laicizations2347415la__icizations
macerations1548475ma___cerations
machinating1945615machi__nati_ng
machinators1854405machi__nat_ors
macroevolutions2281615macroevolutions
maculation14510985ma___culation_
magnifications2245115magnifications
manipulation1654665ma_nipulation_
marginations1546455margi__nations
marinations13411275ma_ri__nations
mastication15610295mastic__ation_
matriculating1863985matriculati_ng
maximizations3354885ma_ximizations
mechanizations3055815mechanizations
medications1649935m_edic__ations
meliorations1466755m_eli_orations
methylations2053685meth__ylations
metrications1649835metric__ations
miscalculations2172835miscalculations
mutilations1348645m_uti__lations
oscillations1445115osc_i_llations
pacifications2267355pac_ifications
participations2054535participations
percolations1648055__percolations
recalculations18104035recalculations
recirculations1884225recirculations
reticulations1556615_reticulations
sacculation1547845sac__culation_
spiculations1646175__spiculations
vaccinations1945685vac__cinations
vacillation1645315vac_i_llation_
vacuolation1644395vac__uolation_
vaticinations1845035va_ticinations
vermiculations2153915vermiculations
vesiculations1845325_vesiculations
violations1337965___vi_olations

Search took 7 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.376475242.0
2DLD Change Limit95024906.35614950.3
3Display Results90900.0631428.6
 (SQL Overall)178691906.79526297.4
 
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.