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

286 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
went7605187(None) 
bent67759911bent
cent67451011cent
dent57158411dent
gent56954391gent
hent76656381hent
kent86846961kent
lent46360531lent
pent66559071pent
rent46661241rent
sent46963011sent
tent46159861tent
vent76049051vent
want76156171want
weet75254151weet
weft105435011weft
welt75547861welt
wen66249601wen_
wend85330451wend
wens76337931wens
wept95635051wept
wert79749821wert
west75748081west
wet65966621we_t
wont75842501wont
agent65829642agent
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
dwelt94316522dwelt
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
keet85347342keet
kelt85343192kelt
ken76343982ken_
keno87926432keno
kens85435232kens
kente95821072kente
kept106232942kept
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
runt46647992runt
scent75831622scent
seat47575562seat
sect67443622sect
sen36058522sen_
send55237292send
sene46848052sene
sente56432882sente
senti56226702senti
sept65844362sept
set36681252se_t
sett45949052sett
sext117338092sext
shent85933502shent
spent75532832spent
stent55634512stent
sweat85628402sweat
sweet85330522sweet
swept105720602swept
teat45963632teat
ten35856112ten_
tend56433772tend
tenet55542212tenet
tens45647412tens
tenth85421832tenth
tents56434212tents
tenty86121602tenty
test48651622test
tet39274992te_t
text116033932text
tint46758862tint
tweet84823982tweet
twenty1236222twenty
vena76126292vena
vend86626422vend
vents86125932vents
vert77249372vert
vest75743602vest
vet65958522ve_t
vext146927762vext
waft106139002waft
wait75553692wait
wan66761942wan_
wand85833882wand
wane76344722wane
wank115632512wank
wans76452272wans
wants87932212wants
wany106432362wany
wart77866082wart
wast75655852wast
wat67378922w_at
watt75545412watt
we57043452we__
weak117126302weak
weal75838682weal
wean75734352wean
weans85326742weans
wear75836722wear
web85735562we_b
webs96622122webs
wecht13415442wecht
wed75843622we_d
weds86628932weds
wee66760812we_e
weed85637512weed
week116428152week
weel75834082weel
ween75835462ween
weens85224052weens
weeny115316162weeny
weep95131652weep
weer75535092weer
wees76249122wees
weest85026772weest
weets85427722weets
wefts116715492wefts
weir76019922weir
weka117013872weka
weld84727732weld
well75832042well
welts85225192welts
wench136214782wench
wends95822812wends
wenny114412462wenny
were76238332were
wests85727002wests
wets75940292wets
what105434072what
wheat114924572wheat
when105723042when_
whens114618762whens
whet105133782whet
whit104834172whit
wilt76246292wilt
win66456292win_
wind85533852wind
wine74953422wine
wing86339222wing
wink116435022wink
wino75933612wino
wins75949172wins
winy107034322winy
wisent93516342wisent
wist78049292wist
wit66563772w_it
won66252062won_
wonk116125302wonk
wons74942042wons
wonts87621542wonts
wort76654752wort
wost76544362wost
wot610467482w_ot
wren78221682wren_
wrens85016242wrens
wrest84925432wrest
writ75537912writ
wyn95921442wyn_
wynd116114462wynd
wynn105811292wynn
wyns105717032wyns
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.280638182.1
2DLD Change Limit298722861.06328101.6
3Display Results2862860.1402042.9
 (SQL Overall)1786912861.483120492.9
 
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.