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 “kent” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

267 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
kent8684696(None) 
bent67759911bent
cent67451011cent
dent57158411dent
gent56954391gent
hent76656381hent
keet85347331keet
kelt85343191kelt
ken76343981ken_
keno87926431keno
kens85435231kens
kente95821061kente
kept106232941kept
lent46360531lent
pent66559071pent
rent46661241rent
sent46963011sent
tent46159861tent
vent76049051vent
went76051871went
agent65829642agent
akene95818662akene
ament76036542ament
anent54931842anent
ant37270792_ant
aunt46553652aunt
beat66168302beat
beet66457542beet
belt65754032belt
ben56554922ben_
bend76435262bend
bene66439492bene
bens65945702bens
bento75922952bento
bents76033692bents
best66355322best
bet58376672be_t
bint67355042bint
blent76230952blent
brent75734132brent
bunt65850852bunt
cant66362032cant
celt65646712celt
cento76625172cento
cents74730332cents
centu76119412centu
cunt66243672cunt
debt77139022debt
deet57356582deet
deft85540222deft
delt57855272delt
den47554342den_
dene56643412dene
deni56929392deni
dens55945072dens
dents65031802dents
deny86027122deny
dint56759052dint
dunt55746872dunt
eat36989052_eat
eft66038822_eft
en28052392_en_
end46834352_end
eng46726782_eng
ens37245922_ens
et26964192_e_t
event85924442event
feat76458222feat
feet75352212feet
feint84732252feint
felt75146932felt
fen66851352fen_
fend84832972fend
fens76139762fens
fest74949442fest
fet66471632fe_t
font77143752font
gelt56448012gelt
gen45950512gen_
gene56237222gene
genet66038682genet
gens55740072gens
gents65729612gents
genu55929072genu
gest56149132gest
get47467462ge_t
hant75461592hant
heat77061422heat
heft106736292heft
hen67555272hen_
hens75642572hens
hents87330742hents
hest75950772hest
het67674312he_t
hint77455742hint
hunt76445492hunt
jest116738502jest
jet106754822je_t
kana85928532kana
kane85133972kane
kart86750802kart
kat77468292k_at
kea76540912ke_a
keas86337092keas
keck94920712keck
keef115829992keef
keek75624962keek
keel85729462keel
keen84830402keen
keens95721182keens
keep106329812keep
keets95123482keets
kef105639662ke_f
kefs115922742kefs
keg86432532ke_g
kegs95824012kegs
keir86217872keir
kelp105322802kelp
kelts95222632kelts
kemp126418762kemp
kempt134318462kempt
kenaf12316032kenaf
kench145513922kench
kendo105113222kendo
kenos95220622kenos
kentes105118642kentes
kep96437202ke_p
kepi105315632kepi
keps106027302keps
kerb104322712kerb
kerf115827462kerf
kern85326212kern
kerne94718212kerne
kerns94719562kerns
keto86223452keto
kex146029582ke_x
key105833332ke_y
keys116322162keys
khat116730722khat
khet116328622khet
kilt86144412kilt
kin76353962kin_
kina85631992kina
kind96128552kind
kine85643422kine
king95933652king
kink76034392kink
kino86233612kino
kins85747902kins
kist86540792kist
kit78559872k_it
knee85323602knee
knelt94617682knelt
knew115912122knew
knit85728142knit
knot85630502knot
konk79320612konk
kuna85120702kuna
kune85424572kune
kyat116025522kyat
leant56737782leant
leet45957902leet
left76340482left
lend56233672lend
leno47331392leno
lens46146492lens
lento57223392lento
lept66440882lept
lest46956322lest
let36481472le_t
lint416266232lint
lunt46148842lunt
meant76537212meant
meat66359602meat
meet65350552meet
melt65752892melt
men59252852men_
mend75334032mend
meno66031362meno
menta74424422menta
menu65130232menu
met56072432me_t
mint66758062mint
neat46356782neat
nene45932062nene
nest45548732nest
net36670292ne_t
nett46643232nett
newt76933742newt
next116631082next
pant66061262pant
peat65967932peat
pelt67651082pelt
pen56558842pen_
pend75934532pend
pens65649642pens
pert66759322pert
pest65555292pest
pet56477302pe_t
pint66963172pint
punt65747202punt
rant45864682rant
reft75141272reft
rend56136572rend
rente54733782rente
rents55935182rents
rest46459842rest
ret35982832re_t
runt46647982runt
scent75831622scent
seat47575562seat
sect67443622sect
sen36058522sen_
send55237292send
sene46848052sene
sente56432872sente
senti56226702senti
sept65844362sept
set36681252se_t
sett45949052sett
sext117338092sext
shent85933502shent
skeet95429182skeet
skene96118122skene
skint95629222skint
sklent103614352sklent
spent75532832spent
stent55634512stent
teat45963632teat
ten35856112ten_
tend56433772tend
tenet55542212tenet
tens45647412tens
tenth85421832tenth
tents56434212tents
tenty86121602tenty
test48651622test
tet39274992te_t
text116033932text
tint46758862tint
unkent103116052unkent
vena76126292vena
vend86626422vend
vents86125932vents
vert77249372vert
vest75743602vest
vet65958522ve_t
vext146927762vext
want76156172want
weet75254152weet
weft105435012weft
welt75547862welt
wen66249602wen_
wend85330452wend
wens76337932wens
wept95635052wept
wert79749822wert
west75748082west
wet65966622we_t
wont75842502wont
yen66847382yen_
yens75832262yens
yenta83917042yenta
yente86220042yente
yet66960692ye_t
yett76434492yett
zest136035702zest

Search took 2 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 Filter178691298720.1401276364.3
2DLD Change Limit298722670.98330388.6
3Display Results2672670.0465804.3
 (SQL Overall)1786912671.169152858.0
 
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.