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

240 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
bends8562897(None) 
bands85233431bands
beads85429501beads
beds75937791be_ds
bend76435261bend_
bendy115017251bendy
bendys12518381bendys
benes75536231benes
bens65945701ben_s
bents76033691bents
binds86627481binds
blends96012881blends
bonds86126841bonds
bunds85523541bunds
ends56528531_ends
fends96324971fends
lends65326251lends
mends84927691mends
pends85527191pends
rends65129951rends
sends65528241sends
tends65425581tends
vends95520891vends
wends95822811wends
amends94713282amends
ands57833622_ands
bads77048872b_ads
balds85524642balds
band76740922band_
banda85223112banda
bandas95120542bandas
bandy114824192bandy
banes74945582banes
bangs85627782bangs
banks115527902banks
banns75321232banns
bans66555142ban_s
bards87139642bards
bauds85821042bauds
bawds116115492bawds
bead75937922bead_
beady114719922beady
beaks115326622beaks
beams95328172beams
beanos85516512beanos
beans75734692beans
beards94116672beards
bears75739042bears
beats76042242beats
beaus75127112beaus
becks135522012becks
bed67950632be_d_
bedu75923702be_du
beedi8711662beedi
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382be_es
beets76131442beets
begs75733832be_gs
behinds1335282behinds
beings94613032beings
bells76432162bells
bels66142492be_ls
belts75931162belts
bemas96424282bemas
ben56554922ben__
bench125619502bench
benday123810812benday
bendays13327512bendays
bended105521232bended
bendee94121022bendee
bendees103913862bendees
bender95223302bender
benders104021062benders
bene66439492ben_e
benne76521122benne
bennes86019012bennes
benni74715362benni
bennis84314802bennis
benny105217362benny
bent67759912ben_t
bento75922952bento
bentos86218302bentos
bergs84718042bergs
berks115423122berks
berms95323662berms
bes56557432be__s
beses75830722beses
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442be_ts
beyonds1335062beyonds
beys913829552be_ys
bids75838462b_ids
bields94110002bields
bind76234522bind_
bindi85617022bindi
bindis94614582bindis
bines76946792bines
bins66548262bin_s
bints76130182bints
birds85421342birds
bleeds95211592bleeds
blend85317452blend_
blende95413442blende
blendes104713682blendes
blinds95111612blinds
blonds95213342blonds
bods76244722b_ods
bolds85825282bolds
bond75334362bond_
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
bounds94415802bounds
brads85528292brads
brands95118942brands
breads95419202breads
breeds94914882breeds
brens75823362bren_s
brents84717272brents
buds75235182b_uds
bunas75126572bunas
bund75530662bund_
bundt85824852bundt
bundts95010842bundts
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
burds84626062burds
cents74730332cents
deads75726912deads
deeds75423762deeds
denes65639722denes
dens55945072den_s
dents65031802dents
eds46638932_e_ds
elds56324862_elds
emends95711432emends
end46834362_end_
engs56121392_engs
ens37245922_en_s
feds85234322fe_ds
feeds94921142feeds
fend84832972fend_
fens76139762fen_s
feods99516852feods
feuds95914882feuds
fiends104110292fiends
finds95424832finds
fonds95824822fonds
funds94119252funds
geds66730822ge_ds
gelds75118342gelds
genes65133092genes
gens55740072gen_s
gents65729612gents
genus65319832genus
hands95327382hands
heads95127112heads
heeds95420422heeds
hens75642572hen_s
hents87330742hents
herds96424682herds
hinds96721482hinds
kendo105113232kendo
kendos114510662kendos
kenos95220622kenos
kens85435242ken_s
kinds106221832kinds
lands65426902lands
leads66028492leads
lend56233672lend_
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
leuds66214812leuds
meads85425322meads
meds75735372me_ds
meeds84920272meeds
melds84822382melds
menads95514382menads
mend75334032mend_
menus75822842menus
minds85427132minds
needs65719632needs
nenes55329672nenes
nerds65719252nerds
peds75835252pe_ds
pend75934532pend_
penes75839222penes
penis75129322penis
pens65649642pen_s
ponds85323402ponds
rands65930452rands
reads64835272reads
redds74617832redds
reds56042872re_ds
reeds65430902reeds
rend56136572rend_
rents55935182rents
rinds64826152rinds
rynds9569972rynds
sands65228582sands
scends95213002scends
seeds64330062seeds
send55237292send_
shends105313772shends
sneds65715352sneds
spends94714472spends
teds54932582te_ds
teinds738262teinds
tend56433772tend_
tendu67216002tendu
tendus75111182tendus
tens45647412ten_s
tents56434212tents
trends75513542trends
unbends10236992unbends
upends9438762upends
velds95615582velds
vend86626422vend_
vents86125932vents
venus84918902venus
wands96425482wands
weds86628942we_ds
weeds95222212weeds
welds94719162welds
wend85330452wend_
wens76337932wen_s
winds95425612winds
wynds126310372wynds
yens75832262yen_s
zeds145821812ze_ds

Search took 3 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 Filter178691538000.300595636.7
2DLD Change Limit538002401.62333148.5
3Display Results2402400.0633809.5
 (SQL Overall)1786912401.98689975.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.