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

224 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
mends8492769(None) 
amends94713281amends
bends85628971bends
emends95711431emends
ends56528531_ends
fends96324971fends
lends65326251lends
meads85425321meads
meds75735371me_ds
meeds84920271meeds
melds84822381melds
menads95514381menads
mend75334031mend_
menus75822841menus
minds85427131minds
pends85527191pends
rends65129951rends
sends65528241sends
tends65425581tends
vends95520891vends
wends95822811wends
amend85717752amend_
amens75624842amen_s
aments85219802aments
ands57833622_ands
bands85233432bands
beads85429502beads
beds75937792be_ds
bend76435262bend_
bendy115017252bendy
bendys12518382bendys
benes75536232benes
bens65945702ben_s
bents76033692bents
binds86627482binds
blends96012882blends
bonds86126842bonds
bunds85523542bunds
cents74730332cents
deads75726912deads
deeds75423762deeds
denes65639722denes
dens55945072den_s
dents65031802dents
eds46638932_e_ds
elds56324862_elds
emend86214892emend_
emyds1144922emyds
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
impends12376802impends
kendo105113232kendo
kendos114510662kendos
kenos95220622kenos
kens85435252ken_s
kinds106221832kinds
lands65426902lands
leads66028492leads
lend56233672lend_
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
leuds66214812leuds
mads76845382m_ads
maenads1037372maenads
maids86327152maids
manas76240432manas
manes76648962manes
manos74933622manos
mans66354552man_s
manus75924932manus
mauds85519272mauds
maunds9519652maunds
mead75531602mead_
meals75933382meals
means75831232means
meats75034052meats
med66146752me_d_
meed74934702meed_
meets74224612meets
megs75530632me_gs
mehndi1233152mehndi
mehndis1343582mehndis
meld75830472meld_
mells75031332mells
mels65941532me_ls
melts74930102melts
memes94927702memes
memos95719112memos
mems85931502me_ms
men59252852men__
menad85918982menad
mended104418682mended
mender93520792mender
menders103818802menders
meno66031362men_o
mensa75318672mensa
mensas85115862mensas
mense75025632mense
menses84222452menses
mensh105413562mensh
menta74424422menta
menu65130232men_u
menudo945792menudo
menudos1034642menudos
meous76120062meous
meows104612682meows
mercs96020452mercs
merde84320122merde
merdes94518602merdes
meres75143572meres
merks114722402merks
merls77423902merls
mesas76823202mesas
mesnes85216212mesnes
mess65932432me_ss
metes74736212metes
meths105320232meths
metis75025902metis
mewls105813232mewls
mews96629332me_ws
mezes167719262mezes
mids76541802m_ids
miens76118302mien_s
milds86422062milds
minas75434112minas
mind75434392mind_
mines75651952mines
minis75432992minis
minks115829272minks
mints76834042mints
minus75223932minus
mods77945062m_ods
molds85324832molds
monads94515302monads
monas74732152monas
monde85723142monde
mondes94322352mondes
mondo85721232mondo
mondos95217332mondos
monks116123392monks
monos75930862monos
mons68152262mon_s
moods85224622moods
mounds93915132mounds
muds75530662m_uds
munis75022002munis
muns65535922mun_s
mynas105815232mynas
needs65719632needs
nenes55329672nenes
nerds65719252nerds
omens75618962omen_s
peds75835252pe_ds
pend75934532pend_
penes75839222penes
penis75129322penis
pens65649642pen_s
ponds85323402ponds
rands65930452rands
reads64835272reads
redds74617832redds
reds56042872re_ds
reeds65430902reeds
remends105013032remends
rend56136572rend_
rents55935182rents
rinds64826152rinds
rynds9569972rynds
sands65228582sands
scends95213002scends
seeds64330062seeds
send55237292send_
shends105313772shends
sneds65715352sneds
spends94714472spends
teds54932582te_ds
teinds738262teinds
tend56433772tend_
tendu67216002tendu
tendus75111182tendus
tens45647412ten_s
tents56434212tents
trends75513542trends
upends9438762upends
velds95615582velds
vend86626422vend_
vents86125932vents
venus84918902venus
wands96425482wands
weds86628942we_ds
weeds95222212weeds
welds94719162welds
wend85330452wend_
wens76337932wen_s
winds95425612winds
wynds126310372wynds
yens75832262yen_s
zeds145821812ze_ds

Search took 7 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.796224486.2
2DLD Change Limit538002245.14010466.9
3Display Results2242240.1261777.8
 (SQL Overall)1786912246.06229477.2
 
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.