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

276 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
upsend935688(None) 
upend85011041up_end
upsends10265291upsends
upsent83314061upsent
append1138272append
pend75934532_p_end
pseud867042_pseud
resend75016772resend
send55237292__send
spend85619332sp_end
suspend1036012suspend
unbend9269772unbend
unkend11309222unkend
unsent63820962unsent
upbind11246312upbind
upends9438762up_ends
upheld12115562upheld
upland938862upland
upped103715162uppe_d
upset73222592upse_t
upsets8409682upsets
upstand1045342upstand
uptrend1044292uptrend
upwind12255822upwind
used55722822u_se_d
absent84016993absent
addend9458453addend
amend85717753_amend
aped78538153ap_e_d
appends1236393appends
apse67725383apse__
apses76823913apse_s
arseno6318913arseno
ascend9429733ascend
aspen75216093aspen_
aspens85013353aspens
assent65119953assent
attend7258973attend
augend837633augend
axseed1456993axseed
based85331583base_d
bend76435263__bend
blend85317453_blend
bugseed1136173bugseed
burseed1049503burseed
bused85624493buse_d
bussed94717053busse_d
cased86032413case_d
cupped134413983cuppe_d
cursed94321253curse_d
cusped114312043cuspe_d
cussed94917123cusse_d
defend113910493defend
depend103510923depend
desand84812633desand
descend11248153descend
dispend11289413dispend
distend93312073distend
dosed76626913dose_d
duped95118323dup_e_d
dupped124411643duppe_d
eased65430403ease_d
emend86214893_emend
end46834353___end
expend16247503expend
extend14267523extend
fend84832973__fend
fiend95312983_fiend
friend10388933friend
fused94820443fuse_d
fussed104613803fusse_d
godsend1084043godsend
guised84612173guise_d
hosed95830983hose_d
hosen85623883hosen_
impend11478793impend
intend72310373intend
lagend838743lagend
lapsed94712583lapse_d
lased65132343lase_d
legend837693legend
lend56233673__lend
lysed95011563lyse_d
mend75334033__mend
missend104411373missend
mistend103812523mistend
mused85524583muse_d
mussed94418903musse_d
nosed65524563nose_d
nursed74514673nurse_d
offend13365663offend
oped76230153op_e_d
open66427003op_en_
opened94311863op_ened
opens76118553op_ens
opined95113853opined
opsin7613473opsin_
opsins8411713opsins
opted84914273opte_d
outspend11126203outspend
owsen84210193owsen_
paned85437183_paned
ped66751523_p_e_d
peed76239183_p_eed
peen65938083_peen_
peened94318163_peened
peens76428193_peens
pen56558843_p_en_
pends85527193_p_ends
pens65649643_p_ens
pent66559073_p_ent
pied75035363_pie_d
pined85935323_pined
plead85818463_plead
pled75231433_ple_d
plena75816393_plena
poind84217913_poind
pond75530493_p_ond
posed85828413pose_d
pound84417863_pound
preed85128123_preed
pseudo934713_pseudo
pseuds944793_pseuds
pudenda1142963pudenda
puked124716223puke_d
puled84926523pule_d
pulsed94013723pulse_d
punned93416193punned
pupped105013273puppe_d
pureed95017813pureed
pursed95220883purse_d
puses75532203puse_s
pushed125017463pushed
rased65033933rase_d
relend76116453relend
remend95216553remend
rend56136573__rend
reseed74823293reseed
resends83513713resends
resent63833623resent
risen54621883risen_
rosed65930353rose_d
sand55338473__sand
scend85516293_scend
seed55549483__seed
sen36058523__sen_
sends65528243__sends
sene46848053__sene
sent46963013__sent
shend94719973_shend
sned56026053__sned
spaed85522273spae_d
sped76031493sp_e_d
speed85526623sp_eed
spends94714473sp_ends
spendy124911143sp_endy
spent75532833sp_ent
sphene113412403sphene
spied85427713spie_d
spined95423943spined
splent84720193splent
spread9312533spread
sprent84522383sprent
spued84918473spue_d
subtend1037103subtend
sudsed83911373sudse_d
supped114415703suppe_d
suspends1145143suspends
sussed75015533susse_d
tend56433773__tend
trend64817453_trend
tupped114013233tuppe_d
umped104717273umpe_d
unbends10236993unbends
unbent83216593unbent
unbind93011433unbind
undead82711903undead
unfed94614223unfe_d
unfond10149113unfond
unhand10410383unhand
unkent103116053unkent
unkind113310573unkind
unlead73312373unlead
unled64021073unle_d
unpen72913573unpen_
unpens82511013unpens
unpent83117373unpent
unposed10711903unpose_d
unread73412673unread
unrent63219783unrent
unsaid7411833unsaid
unseal63315473unseal
unseam83313143unseam
unseat64221023unseat
unseen62012623unseen
unsell63512543unsell
unset54532433unse_t
unsets64116163unsets
unsew83912693unse_w
unsewed112911023unsewed
unsewn9298393unsewn
unsews9379363unsews
unsex123512633unse_x
unsexed152410253unsexed
unsexy16296903unsexy
unshed10313773unshed
unshod1067603unshod
unsold71410513unsold
unsound8158433unsound
unspent92610893unspent
unsung736983unsung
unsunk1036333unsunk
unused72012883unuse_d
unwed94114873unwe_d
unwind102610543unwind
upases84112903upase_s
upbear1096493upbear
upbeat10911513upbeat
upbinds12234813upbinds
upbound12134813upbound
upended11267323up_ended
upfield1343033upfield
upfold12124953upfold
upgird10103933upgird
upheap13105213upheap
uphold12126903uphold
upkeep1434143upkeep
uplands1036943uplands
upleap10106843upleap
uplink12388713uplink
upload9257783upload
upon65817583up_on_
upper93714263uppe_r
uppers102912293uppers
upping114013703upping
uprear8168793uprear
uprisen9227353uprisen_
ups55629053ups___
upsending1334903upsending
upshot1138453upshot
upside9289803upside
upsize17267303upsize
upsized19246253upsized
upsoar8105683upsoar
upstands1144093upstands
upstep1035503upstep
upsteps1133743upsteps
upstir835383upstir
upstood1044243upstood
upsweep1442573upsweep
upswell1242723upswell
upswept1443473upswept
upswing1335593upswing
upswung1341783upswung
uptear896783uptear
uptrends1142833uptrends
upward12147163upward
upwell11285803upwell
upwinds13224223upwinds
urged75316033urge_d
urgent73816043urgent
urped84615283urpe_d
ursid6311483urs_id
ursine64114123ursine
use36835163u_se__
user45023003u_se_r
users55817573u_sers
uses44931113u_se_s
using66317963u_sing
usnea539393u_snea
vend86626423__vend
vised95518763vise_d
viseed105310983viseed
wend85330453__wend
wised95123343wise_d
wisent93516343wisent

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.373479064.3
2DLD Change Limit1127162764.86023192.6
3Display Results2762760.0932967.7
 (SQL Overall)1786912765.32633550.7
 
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.