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

91 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
machicolation2211227(None) 
machicolations2391941machicolations
machicolated2251803machicolat_ed
machination18106823machi__nation
matriculation17125383matriculation
acidulation14105404_ac_idulation
articulation1447974_articulation
cachinnation1972424cachi_nnation
fasciculation20133564fasciculation
machinations19115764machi__nations
maculation14510984ma___culation
manipulation1654664ma_nipulation
mastication15610294mastic__ation
matriculations18144784matriculations
sacculation1547844sac__culation
vacillation1645324vac_i_llation
vacuolation1644404vac__uolation
abdication1548225_abdic__ation
accumulation18153805_accumulation
accusation1466905_ac__cusation
acetylation1643785_ac_etylation
acidulations15104815_ac_idulations
activation15610135_acti__vation
acylation1448655_a___cylation
amelioration1464005ameli_oration
annihilation1594505_annihilation
anticipation1668285_anticipation
articulations1546735_articulations
assimilation1455525_assimilation
brachiation18154085brachi___ation
cachinnations2092125cachi_nnations
calculation1548295__calculation
cancelation1547785__cancelation
cantillation1446695canti_llation
capitulation1644595ca_pitulation
chelation1439965__ch__elation
chocolatier1862785__chocolatier
circulation1549395__circulation
consolation13410985__consolation
denticulation1654565denticulation
echolocation1952815_echolocation
emaciation1449285emac_i___ation
emasculation1655235ema__sculation
etiolation1048535__eti_olation
fabrication1846605fabric__ation
facilitation1746575fac_ilitation
fasciculations21133095fasciculations
fractionation1853205fracti_onation
gallicization2574035gallicization
gesticulation1694705gesticulation
isolation9311645____isolation
jactitation2045625jacti__tation
laciniation1346635lac_i_niation
lacrimation1546265lacri__mation
laicization2247905la__icization
maceration1449615ma___ceration
machinating1945625machi__nating
machinator1744585machi__nat_or
macroevolution2171745macroevolution
maculations1569625ma___culations
magnification2145765magnification
manipulations1754115ma_nipulations
margination1447435margi__nation
marination12312815ma_ri__nation
mastications1649415mastic__ations
matriculating1863985matriculating
maximization3255215ma_ximization
mechanization2956325mechanization
medication15411175m_edic__ation
melioration1368185m_eli_oration
methylation1954425meth__ylation
metrication15410655metric__ation
miscalculation2083035miscalculation
mutilation1249755m_uti__lation
oscillation1345505osc_i_llation
pacification2168055pac_ification
participation1955255participation
percolation1549225__percolation
postisolation1553575postisolation
recalculation17114595recalculation
recirculation1764905recirculation
reticulation1448055_reticulation
sacculations1646665sac__culations
spiculation1547035__spiculation
vaccination1846465vac__cination
vacillations1744885vac_i_llations
vacuolations1743785vac__uolations
vaticination1745765va_ticination
vermiculation2054595vermiculation
vesiculation1746115_vesiculation
violation1238445___vi_olation

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.440406115.9
2DLD Change Limit124790918.45314762.8
3Display Results91910.0631444.4
 (SQL Overall)178691918.95619952.1
 
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.