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

99 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
machinators185440(None) 
machinator1744581machinator_
machinates1747322machinat_es
machinations19115762machinations
vaccinators1854142vaccinators
activators1545943_activators
brachiators1853523brachi_ators
buccinators1752773buccinators
fascinators1644703fascinators
lacrimators1553913lacrimators
laminators1247053la_minators
macerators14167483mac_erators
machinate1647953machinat__e
machinated1845663machinat_ed
machinating1945623machinating
machination18106823machination
masticators1546323masticators
vaccinator1744543vaccinator_
abdicators1546264_abdicators
abominators1553914abominators
accentors13116054_accen_tors
activator1446444_activator_
actuators1146444_ac_tuators
agitators1046624_a_gitators
alienators1045784_alienators
alligators1145774_alligators
animators111210424_a_nimators
aspirators1247004_aspirators
aviators11169914_a_vi_ators
avigators13177094_a_vigators
brachiator1753544brachi_ator_
buccinator1652764buccinator_
cacciatore1353404cacci_atore
cachinnates1852344cachinnat_es
cachinnations2092124cachinnations
captivators1853624captivators
castigators1445544castigators
chantors133710264__chan_tors
chelators1448174__chelators
citators10310254__c_itators
deactivators1852574deactivators
decimators1547504dec_imators
dominators1397484_dominators
eliminators1344814eliminators
emanators1147034ema___nators
emancipators1852514emancipators
escheators1574194esch_eators
fabricators1854074fabricators
facilitators1752784facilitators
fascinator1545214fascinator_
fractionators1862134fractionators
kachinas1736344kachina___s
lachrymators22101724lachrymators
lacrimator1453724lacrimator_
laminator1147554la_minator_
maceraters14226634mac_eraters
macerator13217634mac_erator_
machinable1944264machina_ble
machineries1853794machineries
machinery1943094machin__ery
machines15312894machin___es
machinists1745314machin_ists
machismos1863054machi_smo_s
machzors2444114mach___zors
macintosh1641704mac_in_tosh
mackinaws2042434mackina__ws
mackintosh2151034mackin_tosh
maintops1244404ma__in_tops
mandators1247874ma__ndators
marginates13168744marginat_es
marginations1546454marginations
marinates112516384ma_rinat_es
marinations13411274ma_rinations
masticator1446864masticator_
masticatory1854584masticatory
mediators1248924m_edi_ators
meditators1346264m_editators
methylators1953304methylators
minatory1338554m___inatory
mitigators1345374m_itigators
motivators1545184m_otivators
mutilators1266454m_utilators
navigators1464824na_vigators
nominators1277554_nominators
originators1253924originators
pachinkos2042404pachin_ko_s
pacificators2153004pacificators
palliators1245824palli_ators
pollinators1354544pollinators
radiators1049334ra_di_ators
ruminators1286064_ruminators
salivators13135754sa_livators
supinators1245644_supinators
terminators1346034terminators
urinators947634__urinators
vaccinates1746564vaccinat_es
vaccinations1945684vaccinations
vacillators1653334vacillators
vaticinators1763384vaticinators

Search took 10 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 Filter1786911488190.440406115.9
2DLD Change Limit148819999.39015848.7
3Display Results99990.0631571.4
 (SQL Overall)178691999.89318062.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.