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

89 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
machineries185379(None) 
achinesses1539303_achinesses
machinates1747323machin_ates
machinelike2251813machinelike
machinery1943093machiner__y
machines15312893machin___es
millineries1355493millineries
abhenries1444504_abhen_ries
achieves1645524_achi_e_ves
achiness1339704_achine__ss
achondrites1753364_achondrites
amphigories1952544amphigories
archenemies1852634archenemies
archeries14411224arch__eries
ashinesses1339164_ashinesses
babooneries1552434babooneries
cabinetries1544094ca_binetries
cachexies2364164cach__exies
cachinnates1852344cachinnates
canneries11313084__canneries
chanceries1747654__chanceries
chantries14310294__chantries
chicaneries1853924__chicaneries
chicories1688774__chicories
chimeres153511314__chimer_es
chivaries1757434__chivaries
cinerins10414104__c_inerins
engineries1145474_engineries
farrieries1344354farri_eries
fineries112416754___fineries
gaucheries1644544gauch__eries
hatcheries1846524hatch__eries
imaginaries1453724ima_ginaries
itchinesses1644614itchinesses
jacqueries2843334jac_queries
joineries1648104__joineries
lacinesses12312124lac_inesses
lecheries1449074lech__eries
machetes1539634mach__e_tes
machinable1944264machinable_
machinate1647954machin_ate_
machinated1845664machin_ated
machinating1945624machinating
machination18106824machination
machinations19115764machinations
machinators1854404machinators
machine14313494machin___e_
machineable2052174machineable
machined1637304machin___ed
machining1746934machin__ing
machinist1648484machin__ist
machinists1745314machin_ists
machrees1545504mach___rees
macromeres1645754macromer_es
maltinesses13310234maltinesses
manchineel1752114manchine__el
manchineels1851254manchine_els
manginesses1499594manginesses
manlinesses13910194manlinesses
marchionesses2052364marchionesses
mariners103113864ma_riner__s
marshinesses1744964marshinesses
masonries1146854ma_son_ries
massinesses12128694massinesses
masteries111018494ma__steries
matinees102110424ma_tine__es
matinesses12314544ma_tinesses
mazinesses2139924ma_zinesses
midwiferies2051474midwiferies
miniseries1246754m_iniseries
miseries10320404m___iseries
missileries1353554missileries
mockeries17128264moc__keries
muchnesses1744714much_nesses
mushinesses16127324mushinesses
patchinesses1944364patchinesses
pineries102419084___pineries
racinesses12313514rac_inesses
refineries1347064_refineries
sceneries1149394_sc_eneries
shinneries1345724__shinneries
tachinids1544044tachin__ids
tackinesses1737254tackinesses
tanneries9310424ta__nneries
vaccinees1642844vaccine__es
vineries112716044___vineries
wackinesses2036654wackinesses
washinesses1737264washinesses
wineries112316534___wineries

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.436409841.7
2DLD Change Limit148819899.03016480.5
3Display Results89890.0461934.8
 (SQL Overall)178691899.51218785.8
 
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.