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

265 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
expend1624750(None) 
expand16236571expand
expends17217081expends
extend14267521extend
append1138272append
depend103510922depend
emend86214892e_mend
exceed1636172exceed
exed125420592ex_e_d
expands17195732expands
expect1758902expect
expel1448232expe_l
expels1547172expels
expended19136542expended
expender18136842expender
expense16127872expense
expensed18126412expensed
expert15515352expert
expound1744372expound
extends15227112extends
extent132714912extent
impend11478792impend
pend75934532__pend
perpend12259352perpend
spend85619332_spend
upend85011042_upend
addend9458453addend
amend85717753_amend
amped104820513ampe_d
aped78538153_ape_d
appends1236393appends
arpen74418043arpen_
arpens84814823arpens
arpent84822093arpent
ascend9429733ascend
aspen75216093aspen_
aspens85013353aspens
attend7258973attend
augend837633augend
axed128829613ax_e_d
axled135315813axle_d
axmen145112273axmen_
axseed1456993axseed
beeped115313453beepe_d
bend76435263__bend
biped104718833bipe_d
blend85317453_blend
caped104931803cape_d
coextend1842483coextend
compend144010303compend
coped105036843cope_d
copen94826433copen_
copens106119963copens
deepen9339193deepen_
deepened1235663deepened
deepens10307813deepens
defend113910493defend
depends11348993depends
descend11248153descend
despond1137513despond
dispend11289413dispend
doped95326713dope_d
duped95118323dupe_d
eared65139503eare_d
earned74818333earned
eased65430403ease_d
eaten55323053eaten_
eaved95924503eave_d
ebbed104111003ebbe_d
eched116919223eche_d
edged85514533edge_d
effendi1442423effendi
egged85114393egge_d
eked96718023e_ke_d
eland65820393e_land
eloped95914143elope_d
eluent6315483eluent
embed105014303embe_d
emceed1136283emceed
emends95711433e_mends
empery1348683empery
end46834353___end
ended74421263ende_d
ennead736253ennead
enwind10298083enwind
eocene8311613eocene
epee64628503e_pe_e
epees75219833e_pees
ephod1139123e_phod
errand758793errand
erred65915673erre_d
espied9359773espied
ethene93312923ethene
eupnea835033eupnea
even75222273e_ven_
evened101010313e_vened
evens84817103e_vens
event85924443e_vent
examen1538283examen_
examens1637193examens
exapted1736073exapted
exceeds1733843exceeds
excel1437743exce_l
excels1536663excels
except1797653except
excess1546053excess
exec135313943ex_e_c
execs14539723ex_ecs
exert124624143ex_ert
exes116530813ex_e_s
exeunt1338703exeunt
exigent1539513exigent
exiled144712463exiled
exine125518493ex_ine
exines135715803exines
exing136016813ex_ing
exited144712523exited
exogen1436513exogen_
exogens1536883exogens
exon117116803ex_on_
exons125813343ex_ons
expanded19145163expanded
expander18145803expander
expandor18142763expandor
expanse16145603expanse
expat14313813exp_at
expats1537683expats
expected2036743expected
expects1866883expects
expelled1895883expelled
expenders19145963expenders
expending2045933expending
expenses17138373expenses
experted1838053experted
experts1659063experts
expire1538023expire
expired1736403expired
expiry1834653expiry
explant16310133explant
explode1745963explode
expo1349183exp__o
exponent1747133exponent
export15412183export
expos1449203exp_os
expose1549523expose
exposed1737443exposed
expounds1843233expounds
express1637493express
expunge1743313expunge
expunged1942973expunged
exscind1743753exscind
exsect1558503exsect
exsert13414363exsert
extant132714753extant
extended17135833extended
extender16146333extender
extents142610173extents
extern1348473extern
externe1438573externe
externs1438233externs
exuded15317683exuded
eyed86623233e_ye_d
eyen76223663e_yen_
fend84832973__fend
fiend95312983_fiend
friend10388933friend
gaped96123533gape_d
headend12398363headend
heaped124516903heape_d
helped124714153helpe_d
hempen1338963hempen_
hexed165615763hex_e_d
hoped115628183hope_d
hyped145313333hype_d
imped105117983impe_d
impends12376803impends
intend72310373intend
japed156217633jape_d
jeeped16469843jeepe_d
kelped13449553kelpe_d
kepped15309543keppe_d
keppen14346573keppen_
lagend838743lagend
leaped94317773leape_d
legend837693legend
lend56233673__lend
loped85128333lope_d
mend75334033__mend
moped105424733mope_d
offend13365663offend
oped76230153_ope_d
open66427003_open_
opened94311863_opened
opens76118553_opens
oxen116218593ox_en_
ped66751523__pe_d
peed76239183__peed
peeped113915393peepe_d
pen56558843__pen_
pends85527193__pends
pens65649643__pens
pent66559073__pent
pepped103113403peppe_d
perpends13227753perpends
perpent112318813perpent
piped105123163pipe_d
pond75530493__pond
propend123311273propend
raped85334623rape_d
reaped94122453reape_d
reblend1036653reblend
relend76116453relend
remend95216553remend
rend56136573__rend
reopen8311573reopen_
reopened1138513reopened
reopens939373reopens
repand95316063repand
repent84728873repent
repped114616723reppe_d
resend75016773resend
respond1039113respond
riped85226433ripe_d
ripen75619263ripen_
ripened1038203ripened
ripens85012173ripens
roped84630803rope_d
scend85516293_scend
seeped94317523seepe_d
send55237293__send
serpent92916283serpent
sexed136618543sex_e_d
shend94719973_shend
siped84927683sipe_d
sped76031493_spe_d
speed85526623_speed
spends94714473_spends
spendy124911143_spendy
spent75532833_spent
stipend10386553stipend
suspend1036013suspend
taped85327423tape_d
temped113912893tempe_d
tend56433773__tend
terpene92310863terpene
toped85631313tope_d
trend64817453_trend
typed115815453type_d
umped104717273umpe_d
unbend9269773unbend
unkend11309223unkend
unpen72913573unpen_
unpens82511013unpens
unpent83117373unpent
upends9438763_upends
upped103715163uppe_d
upsend9356883upsend
urped84615283urpe_d
vend86626423__vend
vexed165713113vex_e_d
weekend1533393weekend
wend85330453__wend
wiped114722083wipe_d
yearend11285703yearend
yelped12439363yelpe_d

Search took 6 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.390458182.1
2DLD Change Limit1127162655.48320557.4
3Display Results2652650.0803312.5
 (SQL Overall)1786912655.95330017.0
 
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.