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

108 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
gonadic117721(None) 
gonidic1166101gonidic
monadic1268881monadic
gonad75216052gonad__
gonadal956522gonadal
gonadial1066822gonadial
gonads84511732gonad_s
gonidia975902gonidia
monodic1269782monodic
nomadic1248032nomadic
tornadic1144842tornadic
vanadic1336742vanadic
aggadic1254813aggadic
agnatic10310973agnatic
agonic93515143agon__ic
anodic92813133_anodic
bonaci10310963bonaci_
bonacis11310323bonacis
bonduc1136603bon_duc
boracic1338723boracic
botanic1159583botanic
comatic131816943comatic
comedic14158633comedic
conic95329793con__ic
conidia1069303conidia
dryadic1443633dryadic
dyadic1336093_dyadic
dynamic1545813dynamic
enatic8317563_enatic
enneadic1142773enneadic
fanatic12610703fanatic
faradic1337693faradic
fundic12389083fun_dic
gadi66329733g__adi_
gadid85517383g__adid
gadis74825293g__adis
gamic103916203g__amic
generic101310753generic
genetic101211783genetic
genic85119393gen__ic
genomic1237923genomic
geodic1048003g_eodic
gliadin935593gliadin
gnathic1344843g_nathic
gnomic11248593g_nomic
gnostic1038433gnostic
goad66830983go_ad__
goaded94913713go_aded
goading103112853go_ading
goads77022853go_ad_s
goalie7413163go_alie
goliardic1351943goliardic
gonia64117533gon__ia
gonidial1065943gonidial
gonidium1244213gonidium
gonif94320923gon__if
goodie83613993go_odie
gothic1237793go_thic
gradin83517483g_radin
gynecic1584353gynecic
hagadic1445863hagadic
hexadic2045413hexadic
iodic84816753io__dic
ionic74622663ion__ic
lunatic938753lunatic
maenadic1344613maenadic
monacid121310243monacid
monacidic1643733monacidic
monad85519473monad__
monadal1047893monadal
monades103713823monades
monadical1446133monadical
monadism1348023monadism
monads94515303monad_s
monastic1249863monastic
mosaic10311143mosa_ic
nadir61012973__nadir
naric76824173__naric
nonacid101210843nonacid
nonacidic1444833nonacidic
nonaddict1354143nonaddict
nonbasic1246243nonbasic
nordic939473no_rdic
octadic1245713octadic
odic74920583_o__dic
oghamic1544043oghamic
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 8 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.796224486.2
2DLD Change Limit1340271087.11018850.5
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.95222471.2
 
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.