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

247 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
diadems113539(None) 
diadem1037581diadem_
anadems1036142anadems
deadens93410692deadens
diademed1344152diademed
dialers83614302dialers
diapers104713912diapers
diastems11226522diastems
diatoms1039072diatoms
diodes83915782diode_s
dirdums1134382dirdums
academe1244703academe
academes1344873academes
academy1543093academy
adeems946333__adeems
aiders74524633ai_ders
aides65336603ai_de_s
anadem939183anadem_
beaders104120183beaders
biases84618433biase_s
bidders114012313bidders
biders94822803bi_ders
bides85536773bi_de_s
bidets95215533bi_dets
binders103920743binders
birders103913263birders
bladers104214683bladers
blades95221253blade_s
cades85440733_cade_s
cadets96316513_cadets
ciders94620093ci_ders
cinders104617763cinders
citadels1142843citadels
clades94920463clade_s
daces85030683d_ace_s
dadas75819863d_ad_as
dadoes85616533d_adoes
dados75522433d_ad_os
dads67442773d_ad__s
daikers124010313daikers
daises74318983daise_s
dales66439743d_ale_s
dames85435853d_ame_s
dams77444373d_a__ms
danders93921183danders
darers75921873d_arers
dares66146703d_are_s
daters74827373d_aters
dates65639153d_ate_s
datums936353d_atums
davens104612913d_avens
dazes155024143d_aze_s
deaden83714323deade_n
deader84220473deade_r
deadest93014883deadest
deadeye1245163deadeye
deadeyes1344563deadeyes
deadmen11248573deadmen
deadness1039233deadness
deads75726913dead__s
deafens11317253deafens
dealers84118613dealers
deaves105319533deave_s
decades113615513decade_s
deems85421773d__eems
diabetes1147023diabetes
diacids1137863diacids
diademing1454323diademing
diagrams1246133diagrams
dialect101210263dialect
dialects11126003dialects
dialed84716453diale_d
dialer74315433diale_r
diallers957773diallers
dialogs938103dialogs
dials64925343dia__ls
diamides1238823diamide_s
diamins10312213diamins
diaper94513113diape_r
diapirs10347643diapirs
diaries83321953diaries
diastem10318043diastem_
diastema11264743diastema
diastemas12234393diastemas
diasters92913183diasters
diatom939453diatom_
diazepams2351293diazepams
diazins1739183diazins
dibbers124013173dibbers
dicers94720743di_cers
dices86434243di_ce_s
dickens144410133dickens
dickers144117663dickers
dickeys17479303dickeys
dictums1235553dictums
didacts1186063didacts
diddlers11359153diddlers
diddles103915073diddles
diddleys14334633diddleys
didies84621833di_dies
didoes85716963di_does
didos76820813di_d_os
dienes75719903diene_s
dies55653523di__e_s
diesels8429143diesels
dieses75218693diese_s
dieters83216433dieters
diets66026643di__ets
differs14339973differs
diggers104413393diggers
digress938323digress
dikdiks1242563dikdiks
dikers114418793di_kers
dikes105831333di_ke_s
dilaters92513063dilaters
dilates83220663dilate_s
dildoes9229243dildoes
dildos8179303dild_os
dimers94321093di_mers
dimes85833043di_me_s
dimmers123811563dimmers
dimness1038843dimness
dims75435023di___ms
dindles93817243dindles
diners75525953di_ners
dines66449153di_ne_s
dingers94321383dingers
dinges83825423dinge_s
dingeys12458403dingeys
dinkeys15507263dinkeys
dinkums1433673dinkums
dinners83915443dinners
diode74716113diode__
dipnets10109033dipnets
dippers123615183dippers
dipsades1246493dipsade_s
dirams94413703di_rams
dirdum1036033dirdum_
dirges84915103dirge_s
dirhams13376313dirhams
disarms1039043disarms
dishelms1444723dishelms
dishes104622653dishe_s
dismes95617673disme_s
dispels10310503dispels
disses75225963disse_s
dites66339153di_te_s
dithers114016153dithers
ditzes163212423ditze_s
divers105024963di_vers
dives95832403di_ve_s
dividers13257213dividers
divides123211453divide_s
dizens164911393di_zens
dodders105511793dodders
dodgems12576443dodgems
dogdoms1295423dogdoms
drachms1534253drachms
dragees9359483dragees
drakes114715863drake_s
drams86025833dra__ms
drapers105313353drapers
drapes95419653drape_s
drawees11378363drawees
drawers113610073drawers
dryades12395633dryade_s
duads76515343duad__s
dudes75424373d_ude_s
dumdums1343043dumdums
dyadics1453473dyadics
dyads10549973dyad__s
eiders74321363ei_ders
evaders1136933evaders
evades1039023evade_s
faders105117463_faders
fades94932863_fade_s
finders113717873finders
gilders94212463gilders
girders9379943girders
glades84820343glade_s
graders94716013graders
grades84926313grade_s
hades96035113_hade_s
haems105517013_ha_ems
harems115513823_harems
headers113819393headers
hiders104919653hi_ders
hides95129423hi_de_s
hinders113718503hinders
ideas65919013_i_deas
idem76121063_i_dem_
ides57734233_i_de_s
irades74517393irade_s
items7499613_i_tems
jades135222113_jade_s
kidders13399173kidders
ladens74516233_ladens
laders74927763_laders
lades65141273_lade_s
leadens83610983leadens
leaders83819603leaders
lianes63819323liane_s
lindens839413lindens
loaders83413433loaders
madams11310943_madams
maidens10349663maidens
maihems1444303maihems
miasms1097383mia_sms
middens11379383middens
mildens10339933mildens
mildews13365883mildews
minders103720123minders
misdeems13255653misdeems
modems114610763_modems
naiades838213naiade_s
nides65229133ni_de_s
pinders103720473pinders
raiders84615143raiders
readers83823773readers
ridders93612493ridders
riders74123903ri_ders
rides66140813ri_de_s
roadeos837413roadeos
sades65239893_sade_s
shaders115915553shaders
shades105924533shade_s
sides65838363si_de_s
spaders104214473spaders
spades94222583spade_s
stades74626243stade_s
tandems1037633tandems
tides64830153ti_de_s
tildes74513963tilde_s
tinders84219173tinders
tirades8311723tirade_s
traders84316953traders
trades75724503trade_s
tsades74310993tsade_s
videos104911373vi_deos
waders109120643_waders
wades95634143_wade_s
widders123512273widders
widens106212723wi_dens
wides94832823wi_de_s
wilders113513503wilders
winders113721263winders
wisdoms1335453wisdoms

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.390458182.1
2DLD Change Limit1340272475.92322628.2
3Display Results2472470.0763250.0
 (SQL Overall)1786912476.38927968.5
 
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.