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

205 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
dynode113502(None) 
dynodes1235451dynodes
acnode938202acnode
anode65021042_anode
decode104414742decode
demode104013462demode
denote74118042denote
denude8169352denude
diode74716112d_iode
dyne85320932dyn__e
node513036882__node
synod9610282synod_
synods1077952synods
abode85518813_abode
acnodes1037833acnodes
anodes74418763_anodes
anole55330383_anole
anyone94612733anyone
blonde94813293blonde
bode75838753__bode
bygone1256173bygone
byname13256363byname
canoe75627253cano_e
canoed94618963canoed
cenote83715843cenote
code77347733__code
crunode1034713crunode
cyanide13298843cyanide
cymose13429653cymose
dadoed9449903dadoed
dance85223133dan_ce
danced105315253danced
dander811222993dan_der
dandle84218093dandle
dandy104416703dan_dy
danged94819483danged
dangle84119303dangle
dayside1236173dayside
debone93714783debone
decade104216163decade
decide104116873decide
decoded123212383decoded
decoder113712293decoder
decodes113914983decodes
delude81910673delude
demoded123611123demoded
demoed103713443demoed
demote94817803demote
dene56643413den__e
dengue838253dengue
denied84318633denied
denned84215633denned
denoted93512763denoted
denotes83817003denotes
dense65923503den_se
dented84120513dented
denuded10167663denuded
denuder9167603denuder
denudes91510043denudes
depone93616553depone
depose94215763depose
deride84420033deride
devote104513783devote
dhole95215363d_hole
dildoe8198673dildoe
dindle84417223dindle
dine55555333din__e
dined76431993dined_
dinge75627303din_ge
dinged95221783dinged
dingle84317073dingle
dinked124818353dinked
dinned84317613dinned
dino56036753dino__
dinos65428063dino_s
dinted84419843dinted
diodes83915783d_iodes
dipody1336363dipody
dipole91112853dipole
divide113410893divide
dodge86618133d__odge
dodo66024913d__odo
doe47361953d__o_e
doge66233803d__oge
dole56550003d__ole
dome77240733d__ome
donate73619503donate
done55747913d__one
donee66931013don_ee
dongle83612493dongle
donne65520463don_ne
donned85015743donned
donnee74317063donnee
donor64418193dono_r
donors75115793donors
donsie7613643donsie
doodle83212853d_oodle
doody105517913d_oody
dope76038893d__ope
dore56353303d__ore
dose56442433d__ose
dote55442883d__ote
dove85131563d__ove
doze145829083d__oze
drone65324983d_rone
droned84616863droned
drove95518063d_rove
dude65629663d__ude
duende836923duende
dunce86319263dun_ce
dune56137583dun__e
dunged95414693dunged
dunite7315013dunite
dunked124315283dunked
dunned85015523dunned
dunted84718503dunted
dyable12308983dyable
dyad96415453dy_ad_
dyads10549973dy_ads
dye75334843dy___e
dyed96720763dy_ed_
dyke126418183dy__ke
dyked145310953dyked_
dynamo1274163dynamo
dynast1088223dynast
dynein1035563dynein
dynel9569853dyn_el
dynels10536813dynels
dynes95917583dyn_es
dyvour1393343dyvour
encode9310443encode
epode85114093_epode
erode64520993_erode
eyne76322463eyn__e
genome94312193genome
geode7412593_geode
gnome84213953_gnome
gyrose105310253gyrose
hymnody1942363hymnody
hypoed1547923hypoed
ignore7269063ignore
ionone6313443ionone
joyrode1853303joyrode
keynote1443903keynote
lanose6313593lanose
lode56240113__lode
mode75840303__mode
monde85723143mon_de
monody1238243monody
myope124010973my_ope
nide55535783__nide
nod47549563__nod_
nodes64633493__nodes
nodi56626743__nodi
nods55838223__nods
nome66038423__nome
none45743173__none
nope65934193__nope
nose46739363__nose
note46239963__note
nude56626273__nude
ode47446583___ode
pentode1039893pentode
pinole83218783pinole
pyrone112714473pyrone
pyrope132810533pyrope
recode93618713recode
rode55844303__rode
rynd86414103ryn_d_
rynds9569973ryn_ds
sarode75317513sarode
snide64318723_snide
snore55424953_snore
sonde64622833son_de
spode84617703_spode
strode75215973strode
synced12266963synced
syncope1445383syncope
syndet10311963syn_det
syne75725763syn__e
synodal1145743synodal
synodic1347363synodic
tacnode1045093tacnode
triode75311893triode
trode65322853_trode
tyne76325053tyn__e
tyned95915013tyned_
unde55825483_un_de
unyoke1367293unyoke
venose9310843venose
wynd116114463wyn_d_
wynds126310373wyn_ds
xylose1636763xylose
yod77545503_y_od_
yodel94714083_y_odel
yodh119916103_y_odh
yodle94515043_y_odle
yods86531183_y_ods
yoke115626393_y_oke
yond86122313_yond_
yonder103214133_yonder
yore76335943_y_ore
yowe106728743_y_owe
zygose19455553zygose
zygote19325483zygote

Search took 6 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.393454684.5
2DLD Change Limit1127162054.84323274.0
3Display Results2052050.0603416.7
 (SQL Overall)1786912055.29633740.7
 
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.