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

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

76 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
maintops124440(None) 
maintop1135141maintop_
manitos9314052manito_s
manitous1039172manitous
cantons95221203ca_ntons
cantors94620753ca_ntors
cantos84826973ca_nto_s
dainties9312403dainties
fainters11349693fainters
faints94818783faint__s
fantods11177623fa_ntods
fantoms12189153fa_ntoms
haints94417583haint__s
hardtops1444843hardtops
janitors1536853janitors
laptops1166603la_ptops
lintols7339553_lintols
macintosh1641703macintosh
madtoms1236923ma_dtoms
magnetons1244543magnetons
magnetos1146263magneto_s
maillots1037473maillots
mains75635113main___s
mainstays1443393mainstays
maintain1077723maintain
maintains1167103maintains
maists85817573maist__s
maltols939403ma_ltols
mangoes104316133ma_ngoes
mangos94319343ma_ngo_s
manihots13126443manihots
maniocs113611443ma_niocs
manito8518693manito__
manitou938463manito_u
manitus9310923manit_us
mannitols1143433mannitols
manors84420883ma_n_ors
manos74933623ma_n_o_s
manrope1138033ma_nrope
manropes1237913ma_nropes
mantas85725363ma_nt_as
mantels94515043ma_ntels
mantes84430783ma_nt_es
mantids103113623ma_ntids
mantis83926033ma_nt_is
mantles94820703ma_ntles
mantraps12298063ma_ntraps
mantras93815863ma_ntras
mantuas93410993ma_ntuas
maypops16104453ma_ypops
mentors9314993m_entors
minions93314623m_inions
minnows1234913m_innows
minors85117103m_in_ors
minters93822473m_inters
mints76834043m_int__s
misstops12176413misstops
monitors10310823monitors
painters103013023painters
paints85921833paint__s
palmtops1443543palmtops
pantos85222743pa_nto_s
pintoes95117713_pintoes
pintos86021293_pinto_s
ragtops1035453ra_gtops
rainbows1343243rainbows
raindrops1242813raindrops
saintdoms1242493saintdoms
saints65122423saint__s
sannops936693sa_nnops
santols73513323sa_ntols
santos64421833sa_nto_s
spintos939133spinto_s
taints64520533taint__s
tiptops1136073_tiptops
wantons103713013wa_ntons

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 Filter1786911461620.466383457.1
2DLD Change Limit146162767.67319048.9
3Display Results76760.0302533.3
 (SQL Overall)178691768.16921874.3
 
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.