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

187 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
dyadic133609(None) 
dryadic1443631dryadic
dyadics1453471dyadics
cyanic133110772cyanic
daric85623122d_aric
dyad96415452dyad__
dyads10549972dyad_s
dynamic1545812dynamic
syndic1237302syndic
acidic113612133acidic
adit56443653__adit
adynamic1643343adynamic
agamic113110563agamic
agaric93513643agaric
aggadic1254813aggadic
amidic114012873amidic
anodic92813133anodic
arabic10312733arabic
asdic83814093_asdic
atavic11189293atavic
ataxic15169203ataxic
bardic11312923bardic
baric96125693_baric
basic96220523_basic
cadi75732183_cadi_
cadis84428503_cadis
cadmic1338983_cadmic
cyanid123912043cyanid
cyanin113911453cyanin
cyclic1238033cyclic
cynic124712423cy_nic
cystic132710653cystic
dad58456163d_ad__
dada66422443d_ad_a
dadas75819863d_adas
daddy116212563d_addy
dado67126333d_ad_o
dados75522433d_ados
dads67442773d_ad_s
dais57040703d_a_is
danio6319783d_anio
darics94314113d_arics
davit93424593d_avit
daylit10512493daylit
dead65434243dead__
deaden83714323deaden
deader84220473deader
deadly113811473deadly
deads75726913dead_s
deair65817193dea_ir
dearie73319813dearie
deasil71110983deasil
deific1237313deific
deltic9312503deltic
demic105119193d_emic
dermic114511913dermic
dharmic1535023dharmic
diacid10310633diacid
diacidic1444063diacidic
diadem1037583diadem
diamin9312523diamin
diapir9357113diapir
diazin1639163diazin
dibasic1246033dibasic
didie74120563d_idie
dikdik1152613dikdik
dipodic1397593dipodic
domic104317243d_omic
drail65020973dra_il
drain65222893dra_in
drastic10310883drastic
druidic1143533druidic
dryad10477583dryad__
dryades12395633dryades
dryads11436623dryad_s
duad66521413duad__
duads76515343duad_s
duddie9348863duddie
dyable12308983dyable
dyarchic1943243dyarchic
dyed96720763dyed__
dynamics1644093dynamics
dynastic1445853dynastic
dynein1035563dynein
dysuric1344533dysuric
enatic8317563enatic
faradic1337693faradic
fundic12389083fundic
gadi66329723_gadi_
gadid85517383_gadid
gadis74825293_gadis
gamic103916203_gamic
geodic1048003geodic
gonadic1177213gonadic
gradin83517483gradin
hagadic1445863hagadic
herdic123112303herdic
hexadic2045413hexadic
hyaenic1545993hyaenic
hyalin122210043hyalin
hydric15227953hydric
hyenic1438723hyenic
hypnic1637263hypnic
idyllic1342973idyllic
imidic11358203imidic
iodic84816753_iodic
iridic9328743iridic
italic839903italic
kadi96224833_kadi_
kadis105921063_kadis
khadi1367603khadi_
khadis1446913khadis
laic65931563_la_ic
ludic82912803_ludic
lyric104512723ly_ric
lytic104513033ly_tic
mafic125615463_mafic
magic105818663_magic
malic94525663_malic
manic94629443_manic
medic104619653_medic
monadic1268883monadic
myalgic15134223myalgic
myasis114010473myasis
myopic15308463myopic
myotic133112313myotic
mystic132711643mystic
mythic1637273mythic
nadir61012973_nadir
naric76824173_naric
nomadic1248033nomadic
nordic939473nordic
octadic1245713octadic
odic74920573__odic
oxalic1537093oxalic
oxidic1635943oxidic
padi76331783_padi_
padis86227143_padis
panic93923903_panic
phasic133612053phasic
phatic133014413phatic
pianic103714123pianic
pudic104614563_pudic
pyaemic1645873pyaemic
pyemic1537893pyemic
pyic116915823py__ic
pyknic1734893pyknic
pyric123815073py_ric
pyridic15267833pyridic
qadi145621103_qadi_
qadis155917853_qadis
quadric1946313quadric
rabic93817403_rabic
radii64016413_radii
radio64922493_radio
radix134414603_radix
rhodic12227233rhodic
roadie72813813roadie
sadi55834643_sadi_
sadis64930853_sadis
salic73424713_salic
scaldic1235943scaldic
scandic1237003scandic
sialic8313633sialic
skaldic1443553skaldic
sodic84917493_sodic
spadix1636113spadix
stadia7312143stadia
static83118683static
syndics1335703syndics
synodic1347363synodic
tragic93811553tragic
triadic1037833triadic
tsadi6379913tsadi_
tsadis7429133tsadis
typic124511963ty_pic
uranic82315183uranic
uratic83016363uratic
vanadic1336743vanadic
vatic10316423_vatic
viatic11311453viatic
wadi86228173_wadi_
wadis95223963_wadis
yagi86922243_yagi_
yagis95416573_yagis
yogic116114933_yogic
yonic105920843_yonic

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 Filter1786911127160.376475242.0
2DLD Change Limit1127161875.56320261.7
3Display Results1871870.0603116.7
 (SQL Overall)1786911875.99929786.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.