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 “extend” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

303 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
extend1426752(None) 
expend16247501expend
extends15227111extends
extent132714911extent
attend7258972attend
coextend1842482coextend
eaten55323052eaten_
emend86214892e_mend
exceed1636172exceed
exed125420592ex_e_d
exited144712522exite_d
expand16236572expand
expends17217082expends
extant132714752extant
extended17135832extended
extender16146332extender
extents142610172extents
extern1348472extern
externe1438572externe
externs1438232externs
intend72310372intend
tend56433772__tend
acted88521733acte_d
addend9458453addend
amend85717753_amend
anted66328243ante_d
anteed75616113anteed
append1138273append
ascend9429733ascend
attends8257593attends
attent62818323attent
augend837633augend
axed128829613ax_e_d
axled135315813axle_d
axmen145112273axmen_
axseed1456993axseed
bartend1038753bartend
bated85935533bate_d
beaten84617063beaten_
belted94020633belte_d
bend76435263__bend
bestead10389113bestead
bested94922753beste_d
betted94721163bette_d
blend85317453_blend
butene8312623butene
catena8312483catena
cited84421953cite_d
coextends1942323coextends
contend103511893contend
coted85033853cote_d
dated75530993date_d
defend113910493defend
dented84120513dente_d
depend103510923depend
descend11248153descend
detent73624483detent
dexter143810893dexte_r
distend93312073distend
doted75227073dote_d
eared65139503eare_d
earned74818333earned
eased65430403ease_d
eater54639843eate_r
eaters65535953eaters
eatery95316353eatery
eating75134403eating
eaved95924503eave_d
ebbed104111003ebbe_d
eched116919223eche_d
edged85514513edge_d
edited83913673edite_d
effendi1442423effendi
egged85114383egge_d
eked96718023e_ke_d
eland65820393e_land
elated74725823elate_d
eluent6315483eluent
eluted74915263elute_d
embed105014303embe_d
emceed1136283emceed
emends95711433e_mends
emoted94614923emote_d
end46834353___end
ended74421263ende_d
ennead736253ennead
entente7412953entente
enter54726383ente_r
entera64216833entera
entered82718883entered
enters64425643enters
enwind10298083enwind
eocene8311613eocene
errand758793errand
erred65915673erre_d
esteem838813esteem
ester54727713este_r
esters64627733esters
eterne6311723e_terne
ethene93312923ethene
etna46415263e_t_na
even75222273e_ven_
evened101010313e_vened
evens84817103e_vens
event85924443e_vent
evited104013143evite_d
exacted1737303exacte_d
exalted1537393exalte_d
examen1538283examen_
examens1637193examens
exapted1736073exapte_d
exceeds1733843exceeds
excel1437743exce_l
excels1536663excels
except1797653except
excess1546053excess
excited1737853excite_d
exec135313943ex_e_c
execs14539723ex_ecs
exert124624143ex_ert
exerted152210053exerte_d
exes116530813ex_e_s
exeunt1338703exeunt
exigent1539513exigent
exiled144712463exiled
exine125518493ex_ine
exines135715803exines
exing136016813ex_ing
existed1538473existe_d
existent1548263existent
exiting15311393exiting
exogen1436513exogen_
exogens1536883exogens
exon117116803ex_on_
exons125813343ex_ons
expands17195733expands
expect1758903expect
expel1448233expe_l
expels1547173expels
expended19136543expended
expender18136843expender
expense16127873expense
expensed18126413expensed
expert15515353expert
expound1744373expound
exscind1743753exscind
exsect1558503exsect
exsert13414363exsert
extenders17125673extenders
extending1835853extending
extensor1543913extensor
external1577223external
externes1539833externes
extinct1646893extinct
extol1247893ext_ol
extoll1334863extoll
extols1337683extols
extort13513973extort
extra1239003ext_ra
extras13310223extras
extrema1675013extrema
extreme1645653extreme
extrude1545013extrude
exuded15317683exuded
exulted1536303exulte_d
eyed86623233e_ye_d
eyen76223663e_yen_
fated95632133fate_d
felted103714653felte_d
fend84832973__fend
feted94420933fete_d
fetted104817893fette_d
fiend95312983_fiend
friend10388933friend
gated75329773gate_d
hated95734023hate_d
headend12398363headend
heated104525593heate_d
hefted134911423hefte_d
hented104218753hente_d
hexed165615763hex_e_d
impend11478793impend
intends8239963intends
intent63122773intent
jested144416503jeste_d
jetted143915083jette_d
ketene106613003ketene
kited105120093kite_d
lagend838743lagend
lated65240673late_d
laten54328343laten_
latened8711923latened
latens64620213latens
latent64124303latent
legend837693legend
lend56233673__lend
lenten6312883lenten_
letted74118543lette_d
luted64826143lute_d
mated85537783mate_d
meated94222403meate_d
melted94219063melte_d
mend75334033__mend
meted85424433mete_d
mistend103812523mistend
muted85023383mute_d
neaten64214543neaten_
neatened937043neatened
neatens73310403neatens
neoteny1045023neoteny
nested74720063neste_d
netted74118713nette_d
noted65123843note_d
oaten55222403oaten_
obtund945583obtund
offend13365663offend
often84611413often_
opted84914273opte_d
outed65429063oute_d
oxen116218593ox_en_
oxter123414093oxte_r
oxters134813273oxters
pated85237843pate_d
paten74827343paten_
patens84820863patens
patent84524923patent
pecten102711103pecten_
pectens11189203pectens
pelted94617763pelte_d
pend75934533__pend
pentene9313793pentene
perpend12259353perpend
petted94121523pette_d
portend103411193portend
potent84223353potent
pretend104011013pretend
protend104012793protend
rated65441383rate_d
reblend1036653reblend
relend76116453relend
remend95216553remend
rend56136573__rend
rented74426593rente_d
repetend1136223repetend
resend75016773resend
rested74430783reste_d
retene69224273retene
retted74826313rette_d
rotund737293rotund
sated66238533sate_d
scend85516293_scend
seated75131053seate_d
send55237293__send
sexed136618543sex_e_d
sextan13389643sextan_
sextans14349263sextans
sextant142911963sextant
sextet13916873sexte_t
sextets1497143sextets
sexton133610793sexton_
sextons143710413sextons
shend94719973_shend
sited65130743site_d
spend85619333_spend
stand65923283_stand
stead65520273_stead
steed66024943_steed
steno54716863_steno
stent55634513_stent
subtend1037103subtend
teated74924023teate_d
ted46446563__te_d
teed55439263__teed
teind6213613__teind
ten35856113__ten_
tends65425583__tends
tendu67216003__tendu
tens45647413__tens
tent46159863__tent
tented74221003tente_d
tested74421523teste_d
toted64929483tote_d
trend64817453_trend
unbend9269773unbend
unkend11309223unkend
upend85011043_upend
upsend9356883upsend
uptrend1044293uptrend
vend86626423__vend
vented104617923vente_d
vested104217353veste_d
vetted104316323vette_d
vexed165713113vex_e_d
voted93919143vote_d
weekend1533393weekend
weeted103913793weete_d
welted103715823welte_d
wend85330453__wend
wetted103717023wette_d
wited94727143wite_d
wyted12529473wyte_d
yearend11285703yearend
zested164214043zeste_d

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163035.89019136.8
3Display Results3033030.0933258.1
 (SQL Overall)1786913036.12329183.6
 
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.