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

304 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
sienna64719(None) 
senna54617981s_enna
siennas736121siennas
biennia994932biennia
duenna734592duenna
henna84414042_henna
penna74520202_penna
pinna75320182pi_nna
scena74815782sce_na
sennas64214232s_ennas
sensa54117472s_ensa
sierra637312sierra
siesta639502siesta
signa66114702si_gna
sterna63712762sterna
sunna55016062s_unna
agenda837253agenda
anna45529013__anna
antenna746383antenna
arena55323813are_na
benne76521123_benne
benni74715363_benni
benny105217363_benny
biennale1044103biennale
biennial1065103biennial
blenny1156203blenny
canna75919333_canna
cinema1047653cinema
dieing84018653dieing
diene65720133die_ne
dienes75719903dienes
donna66215033_donna
duennas834143duennas
etna46415263__etna
faena85014203fae_na
fenny115115133_fenny
fiend95312983fie_nd
fiends104110293fiends
fiesta938123fiesta
finca104714503fi_nca
finny114716753fi_nny
frena85915273fre_na
genoa64315823_genoa
genua64614153_genua
gieing83614853gieing
gien56330023gie_n_
ginny95314573gi_nny
goanna736653goanna
hennas94211803_hennas
hieing104216623hieing
hinny115616673hi_nny
hyena11810253hye_na
inia45024703_i_nia
inn36727433_i_nn_
inns46920933_i_nns
jenny153811623_jenny
jinn115420243ji_nn_
jinni125310633ji_nni
jinns126013843ji_nns
kina85632003ki__na
kinema1236023kinema
liana53915893li_ana
lien45339803lie_n_
lienal63912793lienal
liens56525503lie_ns
lierne638023lierne
lignan75510323lignan
limina83514503limina
linen55728723linen_
linens64818393linens
lineny94011443lineny
linga66820823li_nga
linn46034593li_nn_
linns56123333li_nns
manna75522543_manna
mensa75318673_mensa
menta74424423_menta
mien65028363mie_n_
miens76118303mie_ns
mina65136923mi__na
minny104518663mi_nny
mizuna1734303mizuna
ninja1258093ni_nja
ninny84514933ni_nny
omenta83411723omenta
pennae84314033_pennae
penne75423853_penne
penni74617903_penni
pennia84412973_pennia
penny105119453_penny
pieing93917653pieing
pieta75421753pie_ta
pina65842633pi__na
pinene82915653pinene
pineta85815563pineta
pinnae84414643pi_nnae
pinnal84814283pi_nnal
pinnas85315513pi_nnas
pinny105222063pi_nny
pinta75727053pi_nta
pirana8713263pirana
plena75816393ple_na
regna64614813_regna
salina64221123salina
sanga66023803s_anga
sauna54117553s_auna
savanna1043713savanna
scenas84114703scenas
scend85516293sce_nd
scends95213003scends
scene77220573sce_ne
scenes84520353scenes
scenic10510513scenic
scent75831623sce_nt
scents85317023scents
science1138793science
sea36161293s_e__a
sedan65620423s_edan
seeing74222143seeing
seen46943123s_een_
segni63712483s_egni
segno64814743s_egno
seine55732873s_eine
seined74023063seined
seiner64622483seiner
seines65029903seines
seining84020773seining
seitan62613233seitan
selva83014273s_elva
semina8915573semina
sen36058523s_e_n_
send55237293s_e_nd
sendal73314993s_endal
sends65528243s_ends
sene46848053s_e_ne
seneca839793s_eneca
senega738173s_enega
sengi64016513s_engi
sennet64224143s_ennet
sennit63117923s_ennit
senor53822803s_enor
senora63216163s_enora
sense55526823s_ense
sent46963013s_e_nt
sente56432883s_ente
senti56226703s_enti
sepia75318673s_epia
septa75518083s_epta
sera46141393s_e_ra
seta45637313s_e_ta
sewan85921293s_ewan
sewn76124333s_ewn_
shanny124110093shanny
shea76031573she__a
sheen85023313sheen_
sheens95116993sheens
sheeny124912193sheeny
sheila969843sheila
shelta93111793shelta
shend94719973she_nd
shends105313773shends
shent85933503she_nt
sherpa1138093sherpa
shewn115715703shewn_
shinny124810783shinny
siccan1037593siccan
sideman1037973sideman
siding83822133siding
siege66718443sie_ge
sieged85212713sieged
sieges73816833sieges
sieging92613203sieging
siemens938413siemens
sienite7312713sienite
sierran737193sierran
sierras737863sierras
siestas738813siestas
sieur5911893sie_ur
sieurs659043sieurs
sieve84918843sie_ve
sieved104611443sieved
sieves93216003sieves
sieving112311233sieving
sifaka1353553sifaka
sigla64515203si_gla
sigma84513833si_gma
sign55523053si_gn_
signal73711483signal
signed83413753signed
signee73617233signee
signer74015633signer
signet73621153signet
signing92713963signing
signor73510353signor
signora8348503signora
signs65516323si_gns
sika86021323si__ka
silane62718053silane
silence9310223silence
sileni63312143sileni
silent64125843silent
silents73514493silents
silenus7369693silenus
silesia739083silesia
silica8311243silica
silva82714023si_lva
silvan92810153silvan
sima64730783si__ma
simian8811163simian
simnel857023simnel
simony1137903simony
sin36265893si__n_
since75024173si_nce
sine46560623si__ne
sines55954823si_nes
sinew84718923si_new
sinews94210623sinews
sinewy12667513sinewy
sing57544173si__ng
singe65731133si_nge
sings65532703si_ngs
sinh76238043si__nh
sinhs86719603si_nhs
sink86640143si__nk
sinks95529183si_nks
sinned73818413sinned
sinner64320603sinner
sinning83918443sinning
sins46755273si__ns
sinus55523853si_nus
siping94220633siping
siren54525823siren_
sirenian845783sirenian
sirens65318153sirens
siring75128313siring
sirra54416323si_rra
sistra639333sistra
siting74126623siting
sixpenny2041273sixpenny
sizing163616443sizing
skean94415623skean_
skeane104611373skeane
skeans104512913skeans
skeen94817403skeen_
skeens103912913skeens
skein94814413skein_
skeins103911903skeins
skene96118123ske_ne
skenes104616633skenes
skinny13456613skinny
smegma1134113smegma
sonny85016103s_onny
spean74620513spean_
speans85417143speans
spence103813793spence
spend85619333spe_nd
spends94714473spends
spendy124911143spendy
spense83912433spense
spent75532833spe_nt
spinny114510183spinny
splenia948313splenia
stanza1537073stanza
stein54620543stein_
steins64818343steins
stela54019043ste_la
stella63612973stella
stemma10328133stemma
stench114111163stench
stengah1144563stengah
steno54716863ste_no
stenos63915773stenos
stent55634513ste_nt
stents65019453stents
stern55319123stern_
sternal73411913sternal
sterns64616763sterns
sthenia1058503sthenia
sunn45423593s_unn_
sunnah9369353s_unnah
sunnas63914563s_unnas
sunns55017353s_unns
sunny84917743s_unny
swanny12336823swanny
sweeny12358843sweeny
taenia6313193taenia
tenia55324483_tenia
tieing73518763tieing
tinea54923163ti_nea
tinny85317653ti_nny
triennia844563triennia
veena81912323_veena
vena76126293_ve_na
vicuna11115903vicuna
vimina11339943vimina
vina76331803vi__na
vinca105315163vi_nca
wenny114412463_wenny
wiener94513543wiener
wienie9229973wienie
xenia124814773_xenia
yenta83917043_yenta
zenana15297983_zenana
zinnia1536013zinnia

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.373479064.3
2DLD Change Limit1127163045.59620142.2
3Display Results3043040.0933268.8
 (SQL Overall)1786913046.06229477.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.