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

269 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
ends5652852(None) 
ands57833611ands
bends85628971bends
eds46638921e_ds
elds56324851elds
end46834351end_
engs56121391engs
ens37245921en_s
fends96324971fends
lends65326251lends
mends84927691mends
pends85527191pends
rends65129951rends
sends65528241sends
tends65425581tends
vends95520891vends
wends95822811wends
adds67622452adds
ads49755732_ads
aids57846362aids
amends94713282amends
anas46649862anas
and47244172and_
anes45255932anes
anis45746462anis
ants47243472ants
anus47131112anus
bads77048862bads
bands85233422bands
beads85429502beads
beds75937782beds
bend76435262bend_
bendy115017252bendy
bendys12518382bendys
benes75536232benes
bens65945702ben_s
bents76033692bents
bids75838452bids
binds86627472binds
blends96012882blends
bods76244712bods
bonds86126842bonds
buds75235172buds
bunds85523542bunds
cads76144522cads
cents74730332cents
cods76848102cods
cuds76730472cuds
dads67442772dads
deads75726912deads
deeds75423762deeds
denes65639722denes
dens55945072den_s
dents65031802dents
duds65530142duds
ears46356592ears
eats47054872eats
ebbs82411992ebbs
ecus65421462ecus
ed38645182e_d_
eddo63411802eddo
eddy93912092eddy
edh76921562e_dh
edhs86212102edhs
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
egads74610922egads
eggs66516152eggs
egis56520652egis
egos55821652egos
eide55832242eide
eidos65817752eidos
ekes86726602ekes
elands74914772elands
eld46733792eld_
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emends95711432emends
emes65434662emes
ems56435492e_ms
emus66821682emus
emyds1144922emyds
en28052392en__
endash10297122endash
ended74421262ended
ender64325862ender
enders74324052enders
endow94510982endow
endows104610422endows
endue64215352endue
endues73813902endues
eng46726782en_g
enol45823822enol
enols54718402enols
enow77819872enow
enows85115492enows
enuf7323842enuf
envy10411252envy
eons46638712eons
epos66723732epos
eras45441502eras
ergs55523812ergs
ernes55224812ernes
erns45428232erns
eros45238452eros
errs45622532errs
ers36046282e_rs
es29048222e__s
eses45336102eses
esnes54817362esnes
ess36030882e_ss
etas46432272etas
eths76619522eths
etnas54713932etnas
eves76230462eves
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eyes75837882eyes
fads86939872fads
feds85234312feds
feeds94921142feeds
fend84832972fend_
fens76139762fen_s
feods99516852feods
feuds95914882feuds
fids87034742fids
fiends104110292fiends
finds95424822finds
fonds95824822fonds
fuds86528562fuds
funds94119252funds
gads67843382gads
geds66730812geds
gelds75118342gelds
genes65133092genes
gens55740072gen_s
gents65729612gents
genus65319832genus
gids65933742gids
gnus56518002gnus
gods65438042gods
hands95327382hands
heads95127112heads
heeds95420422heeds
hens75642572hen_s
hents87330742hents
herds96424682herds
hinds96721472hinds
hods87239862hods
ids47535472_ids
inks86926502inks
inns46920932inns
ins35945602in_s
kendo105113222kendo
kendos114510662kendos
kenos95220622kenos
kens85435232ken_s
kids96029642kids
kinds106221822kinds
lads56549132lads
lands65426902lands
leads66028492leads
lend56233672lend_
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
leuds66214812leuds
lids56336462lids
mads76845372mads
meads85425322meads
meds75735362meds
meeds84920272meeds
melds84822382melds
menads95514382menads
mend75334032mend_
menus75822842menus
mids76541792mids
minds85427122minds
mods77945052mods
muds75530652muds
nebs66124982nebs
needs65719632needs
negs55727362negs
nenes55329672nenes
nerds65719252nerds
ness45526562ness
nets45941532nets
news76127372news
nods55838222nods
nos38859322_nos
nus37939392_nus
odds68919922odds
ods47546212_ods
olds55926572olds
ones46146532ones
onos46229002onos
ons36148512on_s
onus45826812onus
ouds56430102ouds
pads76742952pads
peds75835242peds
pend75934532pend_
penes75839222penes
penis75129322penis
pens65649642pen_s
pods76540152pods
ponds85323402ponds
puds75630512puds
rads56046602rads
rands65930452rands
reads64835272reads
redds74617832redds
reds56042862reds
reeds65430902reeds
rend56136572rend_
rents55935182rents
rids56539552rids
rinds64826142rinds
rods56442062rods
rynds9569972rynds
sands65228582sands
scends95213002scends
seeds64330062seeds
send55237292send_
shends105313772shends
sneds65715352sneds
sods54940212sods
spends94714472spends
suds56135292suds
tads57143942tads
teds54932572teds
teinds738262teinds
tend56433772tend_
tendu67216002tendu
tendus75111182tendus
tens45647412ten_s
tents56434212tents
tods56141842tods
trends75513542trends
unde55825482unde
undo55620152undo
undy85015162undy
uns35936762un_s
upends9438762upends
urds55922432urds
velds95615582velds
vend86626422vend_
vents86125932vents
venus84918902venus
vids85627542vids
wads87343142wads
wands96425482wands
weds86628932weds
weeds95222212weeds
welds94719162welds
wend85330452wend_
wens76337932wen_s
winds95425602winds
wynds126310372wynds
yens75832262yen_s
yids85224962yids
yods86531182yods
zeds145821802zeds

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 Limit298722690.90632971.3
3Display Results2692690.0634269.8
 (SQL Overall)1786912691.249143067.3
 
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.