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

243 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
upload925778(None) 
unload73010801unload
uploads10266501uploads
busload1044682busload
euploid1038952euploid
load56730602__load
onload7268632onload
plead85818462_plead
plod76723272_plo_d
reload7413892reload
ulnad65611452u_lnad
unlead73312372unlead
unloads8278522unloads
upfold12124952upfold
uphoard1344572uphoard
uphold12126902uphold
upland938862upland
upleap10106842upleap
uploaded1234532uploaded
uproar8106932uproar
upsoar8105682upsoar
abroad9310943abroad
afloat9315153afloat
allod64418373allo_d
aloud65018063_aloud
aplomb1236203aplomb
apod78123183ap_o_d
armload1044283armload
ballad94315323ballad
bloat75229923_bloat
blond85618373_blond
blood85319523_blood
broad84817693_broad
busloads1144153busloads
byroad1236623byroad
carload1039783carload
clad76225823_cl_ad
cloak115214013_cloak
clod76124613_clo_d
cloud86716423_cloud
colead94114643colead
cupboard1544253cupboard
cupola10317693cupola_
cupolaed1342753cupolaed
cupolas11277753cupolas
delead84112343delead
diploid11310283diploid
ephod1139123epho_d
euploids1157243euploids
euploidy1454623euploidy
float85928573_float
flood95215603_flood
glad65624013_gl_ad
gloam86015943_gloam
gloat65427683_gloat
goad66830983__goad
haloed104717593haloed
haloid104317753haloid
haploid1339823haploid
hoptoad1344323hoptoad
hulloa95011183hulloa_
hulloaed12105803hulloaed
hulloas103911913hulloas
hulloed11369793hulloed
iliad64613453_iliad
implead12315823implead
inroad737933inroad
keloid11812613keloid
kilorad1245393kilorad
lad48165703__l_ad
lead56038853__lead
loads65323373__loads
loaf76734903__loaf
loam65630483__loam
loan47436453__loan
loid55531483__loid
lord55032083__lord
loud55228043__loud
meloid9615993meloid
milord999563milord
offload1443203offload
ogdoad943513ogdoad
onloads8246673onloads
opioid9310083opioid
outlead83311103outlead
outplod10106343outplo_d
pad68057323_p__ad
payload1336393payload
plaid85118303_plaid
plan65833943_pl_an
plat66048873_pl_at
play95928983_pl_ay
plea66830603_plea_
pleads94613953_pleads
pleas75627033_pleas
pleat74734473_pleat
pled75231433_pl_ed
pleiad947833_pleiad
plied85118593_plied
plods85719293_plods
ploidy1237483_ploidy
plonk114613983_plonk
plop86625743_plo_p
plops95920333_plops
plot66141233_plo_t
plots75025673_plots
plotz164616993_plotz
plow95923233_plo_w
plowed124213203_plowed
plows105419903_plows
ploy96123603_plo_y
ployed124310563_ployed
ploys105816593_ploys
pod66351483_p_o_d
polar75623453_polar
poled84934843_poled
pond75530493_p_ond
pood75934323_p_ood
pooed85226243_pooed
preload1049813preload
proa66229963_proa_
proas75028803_proas
prod76129503_pro_d
proud84615483_proud
psoae74411623_psoae
psoai7469923_psoai
psoas75012983_psoas
pula65129373pul_a_
puled84926523pul_ed
pulled94322193pulled
pulpal10408453pulpal
pulped114612533pulped
pulsar8329363pulsar
pulsed94013723pulsed
pyoid11513753_pyoid
reloads8911313reloads
reloan6415693reloan
replead10399003replead
road56332113__road
salad65321833sal_ad
shipload1464343shipload
siloed74615303siloed
sloid64619693_sloid
slojd13378843_slojd
sloyd9409683_sloyd
soloed74515743soloed
splat76129343spl_at
splay105816043spl_ay
splore81611303splore
splosh1186543splosh
spread9312533spread
toad55830183__toad
uhlan849113uhl_an
ulan46527393u_l_an
ulna46317323u_lna_
ulnae55214573u_lnae
ulnar56013983u_lnar
ulnas55716533u_lnas
ulpan7310123u_lpan
ulva75412693u_lva_
ulvas84511503u_lvas
unclad938913unclad
uncloak1365473uncloak
uncloud1046433uncloud
undead82711903undead
unfold10179703unfold
unfond10149113unfond
unhood1039233unhood
unlade72714153unl_ade
unlaid7311753unlaid
unlay84613703unl_ay
unleads8228623unleads
unled64021073unl_ed
unloaded1049533unloaded
unloader936643unloader
unlobed10219743unlobed
unlock1248533unlock
unloved112310533unloved
unmold9148313unmold
unplowed1436353unplowed
unread73412673unread
unsold71410513unsold
untold7149683untold
upas68322383up__as
upbear1096493upbear
upbeat10911513upbeat
upbind11246303upbind
upboil1096453upboil
upbore10247883upbore
upbound12134813upbound
upbow1245613upbo_w
upbows1384683upbows
upbraid1244973upbraid
upcoast1165543upcoast
upcoil10126193upcoil
updo76712883updo__
updos8389513updo_s
updove1234483updove
upend85011043up_end
upflow1433523upflo_w
upflowed1742893upflowed
upflows1543513upflows
upfolds13133753upfolds
upgird10103933upgird
upgrade11215823upgrade
upheap13105213upheap
upheld12115563upheld
uphoards1443763uphoards
upholds13135243upholds
uphove1436133uphove
uplands1036943uplands
upleaped1334333upleaped
upleaps1185233upleaps
upleapt11116863upleapt
uplift114610653uplift
uplink12388713uplink
uplit76020803upl_it
uploading1334663uploading
upmost1068193upmost
upo58925863up_o__
upon65817583up_o_n
upped103715163up_ped
uprear8168793uprear
uproars986453uproars
uproot8314123uproot
uprose82311483uprose
upsend9356883upsend
upslope1144173upslope
upsoared11154353upsoared
upsoars985413upsoars
upstand1045343upstand
upstood1044243upstood
uptear896783uptear
uptore8279453uptore
uptorn8268093uptorn
uptoss836093uptoss
uptown11274963uptown
upward12147163upward
upwind12255823upwind
vanload1144703vanload
woad85523943__woad
xyloid1738183xyloid
yclad11246383ycl_ad

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.1561145455.1
2DLD Change Limit1127162436.34317770.1
3Display Results2432430.0803037.5
 (SQL Overall)1786912436.57927160.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.