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

343 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
duendes93819(None) 
duende836921duende_
blendes104713682blendes
denes65639722d_en_es
denies74729642d_enies
denudes91510042d_enudes
dienes75719902dien_es
dudes75424372du__des
dueness82310122dueness
duennas834142duennas
dunces95215752du_nces
dunes65332172du_n_es
durndest1065762durndest
suedes73918112sue_des
addends10356053addend_s
aedes64625143_ae_des
agendas936933agendas
agenes74720253agen_es
akenes104817343aken_es
amended11328313amended
amender10349613amender
amenders11288353amenders
amends94713283amend_s
arenes64928393aren_es
aubades1038753aubades
augends935883augend_s
avenges1157543avenges
avenses1049643avenses
avenues1057183avenues
bended105521233_bended
bendee94121023_bendee
bendees103913863_bendees
bender95223303_bender
benders104021063_benders
bends85628973_bend_s
bendys12518383_bendys
benes75536233_ben_es
bennes86019013_bennes
blende95413443blende_
blended114710713blended
blender104613843blender
blenders115210993blenders
blends96012883blend_s
blondes104213163blondes
bredes94818473bre_des
bundles103515773bu_ndles
bunds85523543bu_nd_s
bundts95010843bu_ndts
bunnies94415003bunnies
burnies94017823burnies
butenes9313033buten_es
cedes84927323_ce_des
censes83721803_censes
damndest1276003damndest
dances95120653d_ances
dander811222993d_ander
danders93921183d_anders
dandies94121443d_andies
dandles94218533d_andles
darndest1067223darndest
daunder9348893daunder
daunders10278473daunders
deaden83714323d_eaden
deadens93410693d_eadens
deader84220473d_eader
deadest93014883d_eadest
deads75726913d_ead_s
deaves105319533d_eaves
debyes1238103d_ebyes
decades113615513decades
decides114217653decides
decodes113914983decodes
deeded94615543d_eeded
deeds75423763d_eed_s
dees56356633d_e__es
defences1439633defences
defended1437223defended
defender1337293defender
defenders1436363defenders
defends12358773defend_s
defenses1237913defenses
defies104624053d_efies
degender1136893degender
degenders1236083degenders
deices94119373d_eices
dekes105224453d_e_kes
deles65139253d_e_les
deludes91810643deludes
delves104917083d_elves
demes86032693d_e_mes
demies94825803d_emies
denars74621433d_enars
dene56643413d_en_e_
dengues938183d_engues
denied84318633d_enied
denier74420693d_enier
deniers84515183d_eniers
denims95214323d_enims
denned84215633d_enned
denotes83817003d_enotes
dens55945073d_en__s
dense65923503d_ense_
denser74115193d_enser
densest83112473d_ensest
dented84120513d_ented
dents65031803d_en_ts
denude8169353d_enude_
denuded10167663d_enuded
denuder9167603d_enuder
denuders10165873d_enuders
depended1337983depended
depends11348993depend_s
derides93420853derides
detentes92712873detentes
deuces94015513d_euces
dexes135224513d_e_xes
dexies145018343d_exies
diene65720133dien_e_
dieses75218693die_ses
dindles93817243d_indles
dines66449153d_in_es
dinges83825423d_inges
diodes83915783d_iodes
dirndls933893dirndls
divides123211453divides
donees74519493d_onees
donnees84210363donnees
doyennes1244363doyennes
dreaded103612023dreaded
dreads84115023dread_s
dredges10379343dredges
drees65628523dre__es
dreidel934473dreidel
dreidels1033213dreidels
dreidls934053dreidls
drenches14309803drenches
dresses83716173dresses
drones75023433dron_es
dryades12395633dryades
duads76515343du_ad_s
duces86327473du__ces
duchies133312313duchies
duckies143613813duckies
dude65629663du__de_
duded84417133du__ded
duds65530143du__d_s
dueled84813663due_led
dueler74213683due_ler
duelers83412053duelers
duelled9359753duelled
dueller8329833dueller
duellers9268223duellers
duellos845763duellos
duels65619233due__ls
duenesses1039333duenesses
duenna734593duen_na
dues56045503du___es
dueted84113593due_ted
duets65323883due__ts
duetted937023duetted
duffles14308923duffles
dufuses11436593dufuses
dukes105023473du__kes
dulness8307983dulness
dulses73913653du_lses
dummies123012133dummies
dunams937833du_nams
dunce86319263du_nce_
dunches133312583dunches
dune56137583du_n_e_
dunged95414693du_nged
dungs75821973du_n_gs
dunites8313593dunites
dunked124315283du_nked
dunker113616463du_nker
dunkers123512193du_nkers
dunks105621193du_n_ks
dunnages10154933dunnages
dunned85015523du_nned
dunner73913823du_nner
dunness8298983dunness
dunnest83312263du_nnest
dunnites947173dunnites
duns55140433du_n__s
dunted84718503du_nted
dunts65828413du_n_ts
duperies11312813duperies
dupes86425933du__pes
durances1158683durances
dures65635923du__res
duresses939173duresses
durned84113173durn_ed
durneder1043233durneder
durnedest1144083durnedest
durns64819863durn__s
durries83817353durries
duties74921903du_ties
duxelles1643963duxelles
dwindles13366023dwindles
dwines105013103dwin_es
dynes95917583d_yn_es
dynodes1235453dynodes
emended11329603emended
emender10649843emender
emenders11319033emenders
emends95711433emend_s
ended74421263__ended
ender64325863__ender
enders74324053__enders
ends56528523__end_s
endues73813903__endues
fences114617113_fences
fended114216913_fended
fender103718723_fender
fenders113717263_fenders
fends96324973_fend_s
fiends104110293fiend_s
flenses1039473flenses
funded114413893fu_nded
funder104016083fu_nder
funders113813933fu_nders
funds94119253fu_nd_s
fundus10429173fu_ndus
funnies104113603funnies
gender83517933_gender
genders93616783_genders
genes65133093_gen_es
genies75324943_genies
genres75515623_genres
gentes75324163_gentes
geodes8412153_geodes
glandes95413833glandes
gledes84915133gle_des
grenades1038433grenades
gudes74520813gu__des
guenons836563guenons
guesses8169373guesses
guides84118283gu_ides
gunnies83413123gunnies
henges104516453_henges
kendos114510663_kendos
kentes105118643_kentes
lender73921273_lender
lenders84419643_lenders
lends65326253_lend_s
lenes54738523_len_es
lenses64620893_lenses
leudes75314093_leudes
lucences12137313lucences
ludes65728853lu__des
lunes55337773lu_n_es
lunges76123423lu_nges
lunies64723013lu_nies
maenades1137473maenades
mended104418683_mended
mender93520793_mender
menders103818803_menders
mends84927693_mend_s
menses84222453_menses
merdes94518603_merdes
mondes94322353_mondes
nenes55329673_nen_es
nuances938523nuances
nudes64723293nu__des
oreides8312023oreides
ounces83617773ou_nces
pedes85327283_pe_des
pended103819013_pended
pends85527193_pend_s
penes75839223_pen_es
quenches2236013quenches
queries16315873queries
queues153510193que_ues
quinces183210433quinces
quintes164114713quintes
redes65139123_re_des
rended84524103_rended
render74024143_render
renders83821673_renders
rends65129953_rend_s
rentes65431193_rentes
rundles83214713ru_ndles
runes55530223ru_n_es
scended11329873scended
scends95213003scend_s
scenes84520353scen_es
sended85121233_sended
sender73824413_sender
senders83022353_senders
sends65528243_send_s
senses63923943_senses
shends105313773shend_s
skenes104616633sken_es
slender83413593slender
sondes74922873_sondes
spences113413923spences
spender103713693spender
spenders113211743spenders
spends94714473spend_s
spenses92913573spenses
suede64419753sue_de_
sueded84014633sue_ded
sundaes8313093su_ndaes
sunder74019823su_nder
sunders84120053su_nders
sundew10369693su_ndew
sundews11398153su_ndews
swedes102711893swe_des
tended83819483_tended
tender74121843_tender
tenders83719723_tenders
tends65425583_tend_s
tendus75111183_tendus
tenses64722553_tenses
tenues63816443_tenues
trended94011763trended
trendies9312213trendies
trends75513543trend_s
tunes55332193tu_n_es
tunnies73614263tunnies
unde55825483_u_nde_
undee65327273_u_ndee
under64624213_u_nder
undies73821963_u_ndies
undoes73917403_u_ndoes
unended92811823unended
upended11267323upended
upends9438763upend_s
ureides8311103ureides
vended114416353_vended
vendee105617263_vendee
vendees114011453_vendees
vender103418423_vender
venders113717003_venders
vends95520893_vend_s
vendues11318623_vendues
venges104015143_venges
venues95115203_venues
weenies102915093weenies
wended113616153_wended
wends95822813_wend_s
wienies102213683wienies
yentes95517603_yentes

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.1561145455.1
2DLD Change Limit1340273436.00022337.8
3Display Results3433430.1262722.2
 (SQL Overall)1786913436.28228444.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.