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

263 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
mend7533403(None) 
amend85717751amend
bend76435261bend
emend86214891emend
end46834351_end
fend84832971fend
lend56233671lend
mead75531601mead
med66146741me_d
meed74934701meed
meld75830471meld
men59252851men_
menad85918981menad
mends84927691mends
meno66031361meno
menu65130231menu
mind75434381mind
pend75934531pend
rend56136571rend
send55237291send
tend56433771tend
vend86626421vend
wend85330451wend
amen66733152amen_
amends94713282amends
amens75624842amens
ament76036542ament
and47244172_and
band76740912band
bead75937922bead
bed67950622be_d
ben56554922ben_
bends85628972bends
bendy115017252bendy
bene66439492bene
bens65945702bens
bent67759912bent
bind76234512bind
blend85317452blend
bond75334362bond
bund75530662bund
cent67451012cent
dead65434242dead
deed65340902deed
den47554342den_
dene56643412dene
deni56929392deni
dens55945072dens
dent57158412dent
deny86027122deny
ed38645182_e_d
eld46733792_eld
emends95711432emends
emyd1047072emyd
en28052392_en_
ends56528522_ends
eng46726782_eng
ens37245922_ens
fed76548352fe_d
feed84538902feed
fen66851352fen_
fends96324972fends
fens76139762fens
feod815523002feod
feud86523022feud
fiend95312982fiend
find87532602find
fond86330952fond
fund85624982fund
ged57044532ge_d
geed65435502geed
geld65828432geld
gen45950512gen_
gene56237222gene
gens55740072gens
gent56954392gent
genu55929072genu
hand86833712hand
head87137172head
heed86437602heed
held85330402held
hen67555272hen_
hens75642572hens
hent76656382hent
herd84933062herd
hind85529752hind
impend11478792impend
jeed125428502jeed
ken76343982ken_
kendo105113222kendo
keno87926432keno
kens85435232kens
kent86846962kent
kind96128562kind
land56337312land
lead56038852lead
led46254552le_d
lends65326252lends
leno47331392leno
lens46146492lens
lent46360532lent
leud57223422leud
lewd85716592lewd
mad68958712m_ad
maenad939412maenad
maid75537662maid
man57465872man_
mana65341962mana
mane65052032mane
maned86634102maned
mano66536812mano
mans66354552mans
many95731862many
maud75325402maud
maund85515452maund
me47748332me__
meads85425322meads
meal65643172meal
mean65538092mean
means75831232means
meant76537212meant
meany104620482meany
meat66359602meat
meds75735362meds
meeds84920272meeds
meek105624832meek
meet65350552meet
meg66040952me_g
mega77620872mega
megs75530632megs
mehndi1233152mehndi
meiny104015412meiny
mel56047482me_l
melds84822382melds
mell64935612mell
mels65941532mels
melt65752892melt
mem77943472me_m
meme85330552meme
memo85924792memo
mems85931502mems
menads95514382menads
mended104418682mended
mender93520792mender
mensa75318672mensa
mense75025632mense
mensed93916542mensed
mensh105413562mensh
menta74424422menta
menudo945792menudo
menus75822842menus
meou65325862meou
meow95117882meow
merc87225622merc
merde84320122merde
mere67244442mere
merk106027942merk
merl65830972merl
mesa67025482mesa
mesh96823002mesh
mesne75116292mesne
mess65932432mess
met56072432me_t
meta65932412meta
mete64438132mete
meted85424432meted
meth95827842meth
mew86137732me_w
mewed115218012mewed
mewl95618322mewl
mews96629332mews
meze154420902meze
mid67354472m_id
mien65028362mien_
miens76118302miens
mild75330852mild
mina65136922mina
minds85427122minds
mine67256172mine
mined85333352mined
mini65634562mini
mink106636532mink
mint66758062mint
minx137723352minx
mod69054402m_od
mold76034332mold
mon57561582mon_
monad85519472monad
monde85723142monde
mondo85721232mondo
monk105928522monk
mono66036722mono
mons68152262mons
mony96830012mony
mood76332062mood
mound83918312mound
mud67336862m_ud
mun56143862mun_
muni65824412muni
muns65535922muns
myna95815302myna
need54934152need
nene45932062nene
nerd56624942nerd
omen66828182omen_
omened93711002omened
omens75618962omens
ped66751522pe_d
peed76239182peed
pen56558842pen_
pends85527192pends
pens65649642pens
pent66559072pent
pond75530492pond
rand55839572rand
read55942532read
red46755802re_d
redd66323172redd
reed55549622reed
remend95216552remend
rends65129952rends
rent46661242rent
rind56535602rind
rynd86414102rynd
sand55338472sand
scend85516292scend
seed55549482seed
sen36058522sen_
sends65528242sends
sene46848052sene
sent46963012sent
shend94719972shend
sned56026052sned
spend85619332spend
ted46446562te_d
teed55439262teed
teind6213612teind
ten35856112ten_
tends65425582tends
tendu67216002tendu
tens45647412tens
tent46159862tent
trend64817452trend
upend85011042upend
veld85323202veld
vena76126292vena
vends95520892vends
vent76049052vent
wand85833882wand
wed75843622we_d
weed85637512weed
weld84727732weld
wen66249602wen_
wends95822812wends
wens76337932wens
went76051872went
wind85533852wind
wynd116114462wynd
yeld811423872yeld
yen66847382yen_
yens75832262yens
yond86122312yond
zed135431172ze_d

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.563317390.8
2DLD Change Limit298722630.76339150.7
3Display Results2632630.0634174.6
 (SQL Overall)1786912631.389128647.2
 
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.