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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

139 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
monadic126888(None) 
gonadic1177211gonadic
monodic1269781monodic
gonidic1166102gonidic
maenadic1344612maenadic
monacid121310242monacid
monacidic1643732monacidic
monad85519472monad__
monadal1047892monadal
monades103713822monades
monadical1446132monadical
monadism1348022monadism
monads94515302monad_s
monastic1249862monastic
mosaic10311142mosa_ic
nomadic1248032nomadic
tornadic1144842tornadic
vanadic1336742vanadic
aggadic1254813aggadic
agnatic10310973agnatic
anodic92813133_anodic
bonaci10310963bonaci_
bonacis11310323bonacis
bonduc1136603bon_duc
boracic1338723boracic
botanic1159583botanic
comatic131816943comatic
comedic14158633comedic
conic95329793con__ic
conidia1069303conidia
dryadic1443633dryadic
dyadic1336093_dyadic
dynamic1545813dynamic
enatic8317563_enatic
enneadic1142773enneadic
fanatic12610703fanatic
faradic1337693faradic
fundic12389083fun_dic
gonad75216053gonad__
gonadal956523gonadal
gonadial1066823gonadial
gonads84511733gonad_s
gonidia975903gonidia
hagadic1445863hagadic
hexadic2045413hexadic
iodic84816753io__dic
ionic74622663ion__ic
lunatic938753lunatic
mafic125615463m__afic
magic105818663m__agic
malic94525663m__alic
manakin131810643manakin
mandalic1347803mandalic
manganic1346993manganic
manic94629443m__anic
mantic104120903man_tic
mantric11311353mantric
medic104619653m__edic
melanic11310403melanic
melodic1238543melodic
menad85918983menad__
menads95514383menad_s
miladi938883miladi_
miladis1049823miladis
minidisc1344143minidisc
modi76826323mo__di_
modica11310063mo__dica
mohair1135203moha_ir
mohalim1446033mohalim
molybdic1842263molybdic
monacids13137513monacids
monadisms1446253monadisms
monadnock1851433monadnock
monandry1443233monandry
monarch1445953monarch
monarchic1844953monarchic
monarda1046613monarda
monardas1145713monardas
monas74732153mona__s
monastics1346803monastics
monatomic1545473monatomic
monaxial1745963monaxial
monaxon1644913monaxon
monazite1957083monazite
monde85723143mon_d_e
mondes94322353mon_des
mondo85721233mon_d_o
mondos95217333mon_dos
monie75631653mon__ie
monistic12311303monistic
monoacid13137223monoacid
monoacidic1752933monoacidic
monobasic1544773monobasic
monodical1447003monodical
monodies11312503monodies
monodist11310923monodist
monody1238243monod_y
monofil1247273monofil
monogamic1645913monogamic
morainic12125673morainic
moronic11311863moronic
morphic1648693morphic
mosaics1138073mosa_ics
motific1446323motific
motivic1445163motivic
motoric11312233motoric
muonic10410183muon__ic
nadir61012973__nadir
naric76824173__naric
nonacid101210843nonacid
nonacidic1444833nonacidic
nonaddict1354143nonaddict
nonbasic1246243nonbasic
nordic939473no_rdic
octadic1245713octadic
odic74920583_o__dic
omnific1443813omnific
ontic74418573_on_tic
oxalic1537093_oxalic
oxidic1635943_oxidic
potamic13310853potamic
roadie72813813ro_adie
scandic1237003scandic
sodic84917493so__dic
somatic111916473somatic
sonantic1048273sonantic
sonic75225293son__ic
spondaic1343013spondaic
sporadic1345053sporadic
syndic1237303syn_dic
synodic1347363synodic
tondi65716143ton_di_
tonemic11310173tonemic
tonetic9313433tonetic
tonic74727653ton__ic
triadic1037833triadic
venatic12311523venatic
vocalic1446943vocalic
yonic105920843yon__ic

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271395.96622465.1
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.43527768.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.