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

303 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
dryades1239563(None) 
dryads11436621dryad_s
arcades101113192arcades
decades113615512decades
drakes114715862dr_akes
drapes95419652dr_apes
drayages1344512drayages
dreaded103612022dreaded
dreads84115022dread_s
dryad10477582dryad__
dryadic1443632dryadic
dyads10549972d_yad_s
grades84926312gr_ades
irades74517392ir_ades
noyades1136562noyades
trades75724502tr_ades
abrades10312073abrades
alcades101011473alcades
arames84622573ar_ames
arcade91013643arcade_
arcaded1178973arcaded
armadas1038173armadas
arrases71214543arrases
aubades1038753aubades
blades95221253_blades
braces108427773br_aces
brads85528293br_ad_s
braes75735053br_a_es
brakes124923123br_akes
braves115524083br_aves
brazes175522193br_azes
breaded115014063breaded
breads95419203bread_s
bredes94818473br_edes
brides94423513br_ides
brigades1236393brigades
broaden10289143broaden
broadens11267243broadens
broader103412613broader
broadest1138573broadest
broads94515153broad_s
brocades1358713brocades
cades85440733__cades
clades94920463_clades
corrades111211263corrades
cradles103114133cr_adles
crakes124921813cr_akes
cranes84330753cr_anes
crapes104727693cr_apes
crases85532313cr_ases
crates85736063cr_ates
craves115825393cr_aves
crazes174720133cr_azes
creases94020963creases
creates95225203creates
crudes96218623cr_udes
crusades1146333crusades
daces85030683d__aces
dadas75819863d__adas
dadoes85616533d__adoes
dados75522433d__ados
dads67442773d__ad_s
dales66439743d__ales
damages11511283damages
dames85435853d__ames
dares66146703d__ares
dates65639153d__ates
daybeds14234473daybeds
daycares1454803daycares
daymares1445333daymares
daysides1335963daysides
dazes155024143d__azes
deaden83714323d_eaden
deadens93410693d_eadens
deader84220473d_eader
deadest93014883d_eadest
deads75726913d_ead_s
deaves105319533d_eaves
debases103814133debases
debates103718533debates
decade104216163decade_
decanes103118913decanes
decares102818533decares
decides114217653decides
decodes113914983decodes
defaces133213403defaces
defames132812253defames
degames113312623degames
degases93413103degases
degrades11269923degrades
dekares122710873dekares
delates83526283delates
deludes91810643deludes
denudes91510043denudes
derates84028893derates
derides93420853derides
dewaxes18297843dewaxes
diadem1037583d_iadem
diadems1135393d_iadems
dilates83220663dilates
diodes83915783d_iodes
dipsades1246493dipsades
divides123211453divides
dolmades1245463dolmades
donates83217223donates
dorados938203dorados
dosages92310803dosages
dotages92311793dotages
doylies114512573doylies
drabs85119673dr_a_bs
draffs13617903dr_affs
drafts105012533dr_afts
dragee84415603dr_agee
dragees9359483dragees
drags75521113dr_a_gs
drails74716953dr_ails
drains73719403dr_ains
drake104918303dr_ake_
dramadies1344813dramadies
dramas95814663dr_amas
drams86025833dr_a_ms
drape85319633dr_ape_
draped105314363dr_aped
draper94315693dr_aper
drapers105313353dr_apers
drapey125010583dr_apey
drats66628373dr_a_ts
drave95219273dr_ave_
drawee104413823dr_awee
drawees11378363drawees
drawer104711363dr_awer
drawers113610073dr_awers
drawls105511393dr_awls
draws95119373dr_a_ws
drayage1234433drayage_
drayed115911393dr_ayed
draymen1335233draymen
drays95819773dr_a_ys
dread74419023dread__
dreamed114310633dreamed
dreamer104110843dreamer
dreamers11369003dreamers
dreams94513983drea_ms
drearies92313413drearies
drears74614253drea_rs
dredges10379353dredges
drees65628523dr__ees
dreidel934473dreidel
dreidels1033213dreidels
dreidls934053dreidls
dresses83716173dresses
dries64733673dr__ies
drives105117113dr_ives
drogues9398393drogues
droids84712583droid_s
drones75023433dr_ones
drosses84513823drosses
droves105116673dr_oves
drowses114610233drowses
drudges10308873drudges
druidess1043083druidess
druids8368093druid_s
drupes94912653dr_upes
druses75517253dr_uses
dryable13237433dryable
dryasdust149803dryasdust
dryer95111463dry__er
dryers10449273dry_ers
dryest104811123dry__est
drylots1143743drylots
dryness11114783dryness
drys86314803dry___s
drywalls1542953drywalls
duads76515343d_uad_s
dudes75424373d__udes
duendes938193duendes
dyad96415453d_yad__
dyadic1336093d_yadic
dyadics1453473d_yadics
dyes85331893d_y__es
dykes135215573d_y_kes
dynes95917583d_y_nes
dynodes1235453dynodes
emydes1236173emy_des
erases64425403er_ases
ergates8314493ergates
erodes74819883er_odes
evades1039023_evades
eyases94513683_eyases
facades1339033facades
fades94932863__fades
frames115119863fr_ames
glades84820343_glades
graces94523493gr_aces
grade75126093gr_ade_
graded94919553gr_aded
grader84919693gr_ader
graders94716013gr_aders
grads75625753gr_ad_s
gradus84411223gr_adus
grapes95123123gr_apes
grates75429893gr_ates
graves104624003gr_aves
grazes164519643gr_azes
greases84816713greases
greaves113311443greaves
grenades1038433grenades
grides84422363gr_ides
gyrases11368313gyrases
gyrates113610263gyrates
hades96035113__hades
hexades18378703hexades
hyraces1537913hyraces
hyraxes2045703hyraxes
invades11118293invades
irade65618153ir_ade_
irides74519123ir_ides
jades135222113__jades
lades65141273__lades
lyases95211873_lyases
monades103713823monades
myases113711553_myases
naiades838213naiades
noyade1036423noyade_
orates64328613or_ates
oreads73915773oread_s
oreides8312023oreides
oroides8311973oroides
oryxes1674523ory_xes
parades104121463parades
parkades1538273parkades
pervades1437353pervades
pesades10310903pesades
pomades123711733pomades
prases84429023pr_ases
prates84633163pr_ates
praxes156215183pr_axes
prefades1439533prefades
prides94324183pr_ides
prudes94215443pr_udes
races74943243_r_aces
rads56046603_r_ad_s
rages64539443_r_ages
rajes125022783_r_ajes
rakes94440353_r_akes
rales54947493_r_ales
rapes75740723_r_apes
rares55247443_r_ares
rases55447213_r_ases
rates55352013_r_ates
raves85441973_r_aves
raxes124729393_r_axes
razes145032703_r_azes
readds84111643_readds
reader73628293_reader
readers83823773_readers
readies83324713_readies
reads64835273_read_s
reales64934123_reales
reaves94127573_reaves
redes65139133_r_edes
rides66140813_r_ides
roadeo7510323_roadeo
roadeos837413_roadeos
roadies83317443_roadies
roads66523623_road_s
rodes614039083_r_odes
ryas77224613_rya__s
ryes75529353_ry__es
rykes125513033_ry_kes
rynds9569973_rynd_s
sades65239893__sades
shades105924533_shades
spades94222583_spades
stades74626243_stades
tirades8311723tirades
torsades937213torsades
traces85329933tr_aces
trade65026043tr_ade_
traded85717683tr_aded
trader75218763tr_ader
traders84316953tr_aders
trapes85024463tr_apes
traves94222743tr_aves
treaded95014283treaded
treader84113833treader
treaders93311843treaders
treadles939703treadles
treads74817923tread_s
triads74513533triad_s
triages82613793triages
tribades1136893tribades
triodes84012503triodes
trystes10419993trystes
tsades74310993_tsades
unlades82612833unlades
urares64519093ur_ares
urases63723563ur_ases
urates65027763ur_ates
ureases74416723ureases
ureides8311103ureides
voyages1435703voyages
wades95634143__wades

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.406440125.6
2DLD Change Limit1340273036.54620474.6
3Display Results3033030.1102754.5
 (SQL Overall)1786913037.06225303.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.