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

309 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
hent7665638(None) 
bent67759911bent
cent67451011cent
dent57158411dent
gent56954391gent
hant75461581hant
heat77061421heat
heft106736291heft
hen67555271hen_
hens75642571hens
hents87330741hents
hest75950771hest
het67674311he_t
hint77455741hint
hunt76445491hunt
kent86846961kent
lent46360531lent
pent66559071pent
rent46661241rent
sent46963011sent
shent85933491shent
tent46159861tent
vent76049051vent
went76051871went
agent65829642agent
ament76036542ament
anent54931842anent
ant37270782_ant
aunt46553652aunt
beat66168302beat
beet66457542beet
belt65754032belt
ben56554922ben_
bend76435262bend
bene66439492bene
bens65945702bens
bento75922952bento
bents76033692bents
best66355322best
bet58376672be_t
bint67355032bint
blent76230952blent
brent75734132brent
bunt65850852bunt
cant66362022cant
celt65646712celt
cento76625172cento
cents74730332cents
centu76119412centu
chant105932692chant
cheat105732452cheat
chert105232102chert
chest104926142chest
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
haen76229452haen_
haet75659502haet
haft105941842haft
haint85436322haint
halt76056302halt
hand86833702hand
hang85535542hang
hank115134132hank
hants86335402hants
hart76865772hart
hast76259482hast
hat67289962h_at
haunt85229132haunt
haut75949732haut
he58151952he__
head87137172head
heal75645692heal
heap96432892heap
hear76143882hear
heart85440742heart
heath115724282heath
heats85838402heats
hebe96424702hebe
heck135826492heck
heed86437602heed
heel75034222heel
hefts116218152hefts
hefty146112132hefty
heh96039622he_h
hehs106723962hehs
heil76328932heil
heir77523802heir
heist87030912heist
held85330402held
hell75637892hell
helm95530022helm
helo75332852helo
helot85332682helot
help95328922help
hem86148732he_m
heme95034412heme
hemp115725622hemp
hems95534942hems
henbit111412002henbit
hence104920042hence
henge94819822henge
henna84414042henna
henry114014472henry
hented104218752hented
hep86644142he_p
her66547812he_r
herb94730962herb
herd84933062herd
here76447102here
herl75834552herl
herm95636152herm
hern76134892hern
herns84825582herns
hero74635782hero
hers75844872hers
hertz174919032hertz
hes66654202he_s
hests85829932hests
heth107028022heth
hets75547202hets
hew97642722he_w
hewn106719852hewn
hews105631572hews
hex137436172he_x
hey96741062he_y
hilt75850712hilt
hin67559562hin_
hind85529752hind
hins76447992hins
hints87330622hints
hist76551542hist
hit66569192h_it
holt77852582holt
hon67759382hon_
hone77549322hone
hong85833952hong
honk116931192honk
hons77350782hons
hoot75752092hoot
host77852832host
hot67776052h_ot
hun65844712hun_
hung86126352hung
hunh106323732hunh
hunk116029542hunk
huns76136932huns
hunts86826172hunts
hurt77142572hurt
hut66457292h_ut
hyena11810252hyena
jest116738502jest
jet106754822je_t
keet85347332keet
kelt85343192kelt
ken76343982ken_
keno87926432keno
kens85435232kens
kente95821062kente
kept106232942kept
khet116328622khe_t
leant56737782leant
leet45957902leet
left76340482left
lend56233672lend
leno47331392leno
lens46146492lens
lento57223392lento
lept66440882lept
lest46956322lest
let36481472le_t
lint416266232lint
lunt46148842lunt
meant76537202meant
meat66359602meat
meet65350552meet
melt65752892melt
men59252842men_
mend75334022mend
meno66031352meno
menta74424422menta
menu65130222menu
met56072432me_t
mint66758042mint
neat46356782neat
nene45932062nene
nest45548732nest
net36670292ne_t
nett46643232nett
newt76933742newt
next116631082next
pant66061252pant
peat65967932peat
pelt67651082pelt
pen56558842pen_
pend75934532pend
pens65649642pens
pert66759322pert
pest65555292pest
pet56477302pe_t
pint66963172pint
punt65747202punt
rant45864672rant
reft75141272reft
rend56136572rend
rente54733782rente
rents55935182rents
rest46459842rest
ret35982832re_t
runt46647982runt
scent75831622scent
seat47575562seat
sect67443622sect
sen36058522sen_
send55237292send
sene46848052sene
sente56432872sente
senti56226692senti
sept65844362sept
set36681252se_t
sett45949052sett
sext117338092sext
sheet84836952sheet
shend94719972shend
shunt85226502shunt
spent75532832spent
stent55634512stent
teat45963632teat
ten35856112ten_
tend56433772tend
tenet55542212tenet
tens45647412tens
tenth85421832tenth
tents56434212tents
tenty86121602tenty
test48651622test
tet39274982te_t
text116033932text
theft114118132theft
then78429692then_
thens85921832thens
tint46758862tint
vena76126292vena
vend86626422vend
vents86125932vents
vert77249372vert
vest75743602vest
vet65958522ve_t
vext146927762vext
want76156162want
weet75254152weet
weft105435012weft
welt75547862welt
wen66249602wen_
wend85330452wend
wens76337932wens
wept95635052wept
wert79749822wert
west75748082west
wet65966622we_t
wheat114924572wheat
when105723042when_
whens114618762whens
whet105133782whe_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.0931921408.6
2DLD Change Limit298723091.09327330.3
3Display Results3093090.0933322.6
 (SQL Overall)1786913091.279139711.5
 
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.