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

532 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
spence10381379(None) 
pence94924451_pence
spencer113610971spencer
spences113413921spences
spense83912431spense
essence947672essence
fence105319912_fence
hence104920042_hence
peace95026082_peace
pencel103812912_pencel
penne75423852_penne
ponce95222512_ponce
sapience12106612sapience
scene77220572scen_e
science1138782science
sconce104711722sconce
seance83716692seance
sene46848052s_en_e
sense55526822s_ense
sente56432882s_ente
silence9310212silence
since75024172s_ince
sixpence1943542sixpence
skene96118122sken_e
space95325672sp_ace
spancel1147362spancel
spec85821972spe_c_
specced14266702specced
specie10412222specie
speck135115652spe_ck
specs96916672spe_cs
speech1347562speech
speise84614252speise
spencers12269192spencers
spend85619332spen_d
spender103713692spender
spends94714472spends
spendy124911142spendy
spenses92913572spenses
spent75532832spen_t
sphene113412402sphen_e
spice95528812sp_ice
spine76534422spin_e
splice104915102splice
sponge939662sponge
spruce103910872spruce
stance84316912stance
stench114111162stench
thence112010842thence
whence14187922whence
absence1137713absence
agency1237033agency
agene65621583agen_e
akene95818663aken_e
amerce10310513amerce
apace94718383ap_ace
apercu1057383apercu
apiece10510083apiece
arene55329413aren_e
askance1345923askance
aspect10612823aspe_ct
aspen75216093aspen__
aspens85013353aspen_s
asperse94210663asperse
avenge1087553avenge
avenue957953avenue
bench125619503_bench
bene66439493_ben_e
benne76521123_benne
blench133710453blench
blende95413443blende
bounce104014833bounce
cadence1239063cadence
cense75121403_cense
chance134617093chance
clench133910053clench
coerce10310403coerce
dance85223133_dance
defence1339893defence
deice84320033_deice
dene56643413_den_e
dense65923503_dense
deuce84517493_deuce
diene65720133dien_e
dispense11129783dispense
drench12369593drench
duende836923duende
dunce86319263_dunce
epee64628503epe__e
esperance1346693esperance
essences1047563essences
evince1137763evince
expense16127873expense
faience1237513faience
fenced124412713_fenced
fencer114613533_fencer
fences114617113_fences
fiance11310743fiance
fierce11348913fierce
fleece11369903fleece
flench144010813flench
flense938903flense
french143511213french
gene56237223_gen_e
genie66124923_genie
genre66016803_genre
glance94312313glance
hance105424153_hance
henge94819833_henge
jaunce15367433jaunce
jounce153310733jounce
kench145513923_kench
kente95821073_kente
lance75126723_lance
launce8469183launce
lense54523433_lense
licence11119363licence
lucence11148003lucence
menace103216943_menace
mense75025633_mense
mince95325233_mince
nance74721843_nance
nascence1256183nascence
nene45932063_nen_e
niece74814503nie_ce
nonce75719823_nonce
nuance859043nuance
offence1545353offence
once65423083__once
open66427003open__
opened94311863opened
opener83910993opener
openly1137123openly
opens76118553open_s
opine77422463opin_e
opulence1245153opulence
ounce77019933_ounce
pace86345773_p_ace
pane64950293_pan_e
panne76623653_panne
peaced115818913_peaced
peaces106324083_peaces
peach125422493_peach
peage84723573_peage
pease75231113_pease
pec76744413_pe_c_
pech116125453_pe_ch
peck125730683_pe_ck
pecs84634103_pe_cs
pee56066513_pe__e
peeve104915253_peeve
peise75825773_peise
peke105926203_pe_ke
pekoe114612363_pekoe
pele65539553_pe_le
pen56558843_pen__
penal75228373_penal
penance11313443_penance
pencels113610053_pencels
pencil103712973_pencil
pend75934533_pen_d
pended103819013_pended
pends85527193_pends
penes75839223_penes
pengo84317593_pengo
penile82219603_penile
penis75129323_penis
penmen10311493_penmen
penna74520203_penna
pennae84314033_pennae
penned94217613_penned
penner84616663_penner
penni74617903_penni
penny105119453_penny
penoche1447043_penoche
pens65649643_pen_s
pensee8417313_pensee
pent66559073_pen_t
penuche1435943_penuche
perch124518833_perch
pere66450263_pe_re
perse75429523_perse
pewee10319973_pewee
pice84641093_p_ice
piece96717993_piece
pierce104010393pierce
pincer104019173_pincer
pinch125619303_pinch
pine67755713_pin_e
place94824613_place
plench134010813plench
ponced114314813_ponced
ponces104720843_ponces
pone65747533_pon_e
potence11711363potence
pounce105214093pounce
prance104318573prance
price93725413_price
prince104114763prince
puce85127883_p_uce
punch125118423_punch
quench2036633quench
quince173910133quince
rance75028513_rance
recce9514563_recce
refence12312233refence
rente54733783_rente
saice75424053s_aice
salience10117903salience
sane45954343s_an_e
saphenae1344853saphenae
sapiences13116423sapiences
sapiency15114493sapiency
sauce75121653s_auce
scarce104013633scarce
scena74815783scen_a
scenas84114703scenas
scend85516293scen_d
scended11329873scended
scends95213003scends
scenes84520353scenes
scenic10510513scenic
scenics1137773scenics
scent75831623scen_t
scented102811883scented
scents85317023scents
sciences1238773sciences
sconced12359173sconced
sconces113811453sconces
scone74621833scon_e
seances93015343seances
sec55945323s_e_c_
secco9312423s_ecco
secs65033893s_e_cs
sect67443623s_e_ct
sedge75019973s_edge
seduce9610023seduce
see35772263s_e__e
seen46943123seen__
seethe93712483seethe
segue6314413s_egue
seiche11811833s_eiche
seine55732873s_eine
seise54727853s_eise
seize143819503s_eize
selle54428313s_elle
seme65836653s_e_me
sen36058523s_en__
senate63725173s_enate
send55237293s_en_d
sended85121233s_ended
sender73824413s_ender
sends65528243s_ends
seneca839793s_eneca
sengi64016513s_engi
senile63420213s_enile
senna54617983s_enna
sennet64224143s_ennet
senor53822803s_enor
sensa54117473s_ensa
sensed73918163s_ensed
sensei64712593s_ensei
senses63923943s_enses
sent46963013s_en_t
sentence1099863sentence
senti56226703s_enti
sepic94617053sepic_
sequence1946903sequence
sere46153473s_e_re
serene63522353seren_e
serge64727473s_erge
serve85425963s_erve
setae56026223s_etae
sheave124514003sheave
sheenie10159493sheenie
sheeve123412843sheeve
shelve124012763shelve
shend94719973shen_d
shends105313773shends
shent85933503shen_t
sheuch14267043sheuch
shine85533093shin_e
shone83725983shon_e
sice65545593s__ice
siege66718443sie_ge
sienite7312713sienite
sienna647193sienna
sieve84918843sie_ve
signee73617233signee
silenced1136273silenced
silencer1036293silencer
silences10310073silences
sine46560623s_in_e
singe65731133s_inge
sithence1344793sithence
sixpences2043633sixpences
skeane104611373skeane
skee85431473ske__e
skenes104616633skenes
sketch1535363sketch
sleave94714153sleave
sleaze152611863sleaze
sledge85011303sledge
sleeve93411593sleeve
slender83413593slender
slice74925823s_lice
sluice849513sluice
sneck114713663sne_ck
sneeze15318523sneeze
snye77115493s__nye
solace83415823solace
sonance9310313sonance
sonde64622833s_onde
sone46649983s_on_e
source8410673source
spaced114517253sp_aced
spacer104917793sp_acer
spaces104722633sp_aces
spacey136212533sp_acey
spacy125415623sp_acy
spade84423323sp_ade
spae65034323sp__ae
spahee11313443spahee
spake114322743sp_ake
spale74929213sp_ale
span65234663span__
spancels1245273spancels
spandex1735833spandex
spang84919733span_g
spangle1038403spangle
spaniel948923spaniel
spank115919573span_k
spanked143111733spanked
spanker133612353spanker
spanks124514123spanks
spanned104111223spanned
spanner94312563spanner
spans74528733span_s
spare75135563sp_are
sparge94216053sparge
sparse84516343sparse
spate74731583sp_ate
spathe115115693spathe
spavie113611383spavie
speak114618673spe_ak
speaker133311213speaker
speaks125114583speaks
spean74620513spe_an
speaned103411523speaned
speans85417143speans
spear75821063spe_ar
speared104314423speared
spearer93913663spearer
spears84019473spears
species11314133species
specked16329013specked
speckle15297553speckle
specks144312703specks
specter113111733specter
spectre11297773spectre
sped76031493spe__d
speeches1537413speeches
speed85526623spe_ed
speeded113310423speeded
speeder103811073speeder
speedo94011993speedo
speeds94316053speeds
speedy1218410793speedy
speel74420763spe_el
speeled103712453speeled
speels85116393speels
speer74623903spe_er
speered103614813speered
speers85019953speers
speil75618643spe_il
speiled104412123speiled
speils84116223speils
speir75315363spe_ir
speired103811103speired
speirs85013233speirs
speises93813933speises
speiss84311643speiss
spell75020303spe_ll
spelled103714743spelled
speller95415153speller
spells84617683spells
spelt75430193spe_lt
spelter94113703spelter
spelts84614643spelts
speltz174010123speltz
spenders113211743spenders
spendier1147143spendier
sperm93216023spe_rm
sperms102512603sperms
spew95421873spe__w
spewed125512333spewed
spewer115112153spewer
spews105015923spe_ws
sphenes123013163sphenes
sphenic1449093sphenic
sphere113313663sphere
spic85227433sp_ic_
spica94717943sp_ica
spicae104313703spicae
spiced115218313sp_iced
spicer104719313sp_icer
spices104326033sp_ices
spicey134414233sp_icey
spick134519073sp_ick
spics94123243sp_ics
spicy125417713sp_icy
spike114922843sp_ike
spile75230083sp_ile
spin66231303spin__
spinach1435403spinach
spinage10289653spinage
spinal84915313spinal
spinate93114813spinate
spindle103210093spindle
spined95423943spined
spinel85317333spinel
spines85132033spines
spinet85629753spinet
spinier93715163spinier
spinner93912263spinner
spinney12438923spinney
spinny114510183spinny
spinor839943spinor
spinose937943spinose
spins75327983spin_s
spinto8410663spinto
spinule9299993spinule
spiny104921303spin_y
spire75828693sp_ire
spite75430663sp_ite
splake1259783splake
splenia948313splenia
splenic1148663splenic
splenii945543splenii
splent84720193splen_t
splents93912133splents
spliced124310593spliced
splicer114710523splicer
splices113914383splices
spline86020533spline
splore81611303splore
spode84617703sp_ode
spoke114818663sp_oke
spondee10310593spondee
sponged1137953sponged
sponger1038523sponger
sponges10311043sponges
spongy1236743spongy
spore75428593sp_ore
spouse84112513spouse
spree74830863sp_ree
sprent84522383spren_t
springe103913983springe
sprite84421773sprite
spruced12307533spruced
sprucer11317683sprucer
spruces113810503spruces
sprucy13356323sprucy
sprue74717633sp_rue
spue66025523sp__ue
spume95817313sp_ume
spun66221463spun__
spunk114513403spun_k
spunked14307783spunked
spunkie13215303spunkie
spunks12349333spunks
spunky15427163spunky
spurge93711323spurge
stances93715963stances
stanch113812373stanch
stane55933003stan_e
steeve93710903steeve
stelae63716483stelae
stele55026843ste_le
stenches132110293stenches
stenchy15256213stenchy
stencil946893stencil
steno54716863sten_o
stenos63915773stenos
stent55634513sten_t
stents65019453stents
steppe10319873steppe
stere55328543ste_re
stone55431183ston_e
suede64419753sue_de
supine84216693supin_e
suspense10135743suspense
svelte9319753svelte
swede94413203swe_de
swerve1256293swerve
swine85625303swin_e
swinge105614383swinge
syce95820283s__yce
syenite1039773syenite
sync95415103s_ync_
synced12266963s_ynced
synch135011793s_ynch
syncs104610173s_yncs
syne75725763s_yn_e
tenace82715693_tenace
tench105620003_tench
tenge65720453_tenge
tenpence1246403tenpence
tense55225843_tense
terce75721843_terce
tierce8339843tierce
trance84718763trance
trench114211613trench
tuppence1444413tuppence
twopence1542953twopence
unfence1239193unfence
upend85011043upen_d
upended11267323upended
upends9438763upends
usance858013usance
usaunce9103383usaunce
valence1268773valence
venae85920983_venae
venge95117993_venge
venue84918213_venue
weenie92612023weenie
wench136214783_wench
wienie9229973wienie
wince105220883_wince
wrench14439353wrench
yente86220043_yente
yince105214253_yince

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.376475242.0
2DLD Change Limit1127165325.37620966.5
3Display Results5325320.1703129.4
 (SQL Overall)1786915325.92230174.1
 
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.