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

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

69 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
monads9451530(None) 
gonads84511731gonads
menads95514381menads
monad85519471monad_
monades103713821monades
monas74732151mona_s
bonds86126842bon_ds
donas65926472dona_s
fonds95824822fon_ds
goads77022852go_ads
gonad75216052gonad_
hodads1147962hodads
honans94814502honans
hondas10313352hondas
loads65323372lo_ads
mads76845372m__ads
maenads1037372maenads
manas76240432mana_s
manats84623462manats
meads85425322m_eads
menad85918982menad_
mends84927692men_ds
minas75434112mina_s
minds85427122min_ds
moans74624372mo_ans
moas65545342mo_a_s
moats75827642mo_ats
modals93914452modals
mods77945052mo__ds
molars85517322molars
molas75132092mola_s
molds85324832mo_lds
monacids13137512monacids
monadal1047892monadal
monadic1268882monadic
monadism1348022monadism
monarda1046612monarda
monardas1145712monardas
monde85723142mon_de
mondes94322352mondes
mondo85721232mon_do
mondos95217332mondos
moneys115513622moneys
mongos94318622mongos
monies83233162monies
monks116123392mon_ks
monody1238242monody
monos75930862mon_os
mons68152262mon__s
montes84226932montes
months113812932months
moods85224622mo_ods
mopeds11499662mopeds
morals85324632morals
moras76438782mora_s
morass84614502morass
morays114613882morays
moulds94910992moulds
mounds93915132mounds
moxas145014392moxa_s
mynahs14416442mynahs
mynas105815232myna_s
nomads94711602nomads
nonas55126652nona_s
ponds85323402pon_ds
roads66523622ro_ads
sonars64818972sonars
toads65621072to_ads
woads94818442wo_ads

Search took 3 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 Filter178691825510.340525561.8
2DLD Change Limit82551692.19037694.5
3Display Results69690.0302300.0
 (SQL Overall)178691692.56069801.2
 
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.