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

397 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
spreads103976(None) 
spread9312531spread_
bespreads1443502bespreads
breads95419212_breads
dispreads1346002dispreads
dreads84115022_dreads
lipreads1144222lipreads
oreads73915772_oreads
pleads94613952_pleads
reads64835272__reads
rereads81512292rereads
respreads1244522respreads
sapheads1466082sapheads
screaks13469362screaks
screams114810622screams
screeds106210292screeds
shreds105613052shre_ds
speaks125114582sp_eaks
speans85417142sp_eans
spears84019472sp_ears
speeds94316052sp_eeds
spends94714472sp_ends
spireas94412512spirea_s
sprags95715822spr_ags
sprats85819932spr_ats
sprays115913642spr_ays
spreader1137482spreader
spreaders1236502spreaders
sprees85620642spre_es
steads74116222s_teads
streaks114411272streaks
streams94713372streams
threads11419952threads
treads74817922_treads
uprears9107492uprears
airheads1246133airheads
already1144263already
apneas83211383apnea_s
appeals11378673appeals
appears11308953appears
appends1236393appends
apres75426403apre__s
areas55935793_area_s
arrears738853arrears
beads85429503__beads
bedspreads1651803bedspreads
beheads1338523beheads
bespread1344183bespread_
boreas85421743borea_s
brads85528293_br_ads
bread85523113_bread_
bready124511183_bready
breaks124816433_breaks
breams104815053_breams
breeds94914883_breeds
broads94515153_broads
bureaus979303bureaus
byroads1335293byroads
cereals9313173cereals
coheads13289233coheads
coleads102911423coleads
copyreads1743323copyreads
creaks124315963_creaks
creams104715253_creams
creds85418773_cre_ds
creeds94714773_creeds
deads75726913__deads
deleads9379703deleads
dispread1247103dispread_
dread74419023_dread_
dreams94513983_dreams
drears74614253_drears
dryads11436623_dryads
enneads834733enneads
estreats839433estreats
farads104713273far_ads
freaks134713063_freaks
grads75625753_gr_ads
greats76318403_greats
greeds84314283_greeds
heads95127113__heads
hopheads17276613hopheads
impleads13294593impleads
inroads837043inroads
isoleads944373isoleads
jarheads1944793jarheads
jereeds15326393jereeds
kneads11357093_kneads
leads66028493__leads
lipread1034953lipread_
meads85425323__meads
mispleads1444203mispleads
misreads11268923misreads
myriads1334353myriads
nereids838743nereids
operands1146813operands
operas8312453opera_s
oread64619603_oread_
ospreys1233143ospre_ys
outreads9289003outreads
outspreads1342753outspreads
pads76742963_p__ads
paeans85118263_paeans
peags86122843_p_eags
peaks114825623_p_eaks
peals75235493_p_eals
peans75437643_p_eans
pears75138613_p_ears
peas65755063_p_ea_s
peats76140193_p_eats
peds75835253_p_e_ds
pends85527193_p_ends
phreaks1634543phreaks
plead85818463_plead_
pleas75627033_plea_s
pleats85218593_pleats
pleiads1045223_pleiads
praams10459643_praams
prams96125513_pr_ams
praos74923563_pr_aos
prats76333393_pr_ats
praus74621753_pr_aus
prays105022433_pr_ays
preach133613923_preach
preact103220393_preact
preacts113211363_preacts
preamp1238993_preamp
preamps1336623_preamps
prearm104512353_prearm
prearms11369173_prearms
prebade12310283_prebade
prebids12399893_prebids
precis103416713_precis
preed85128123_preed_
preens85020113_preens
prees75937173_pre_es
prefabs1435163_prefabs
prefade1339013_prefade
prefades1439533_prefades
preloads1157523_preloads
premade12311443_premade
premeds12389593_premeds
preops104911953_preops
prepays1437493_prepays
preps96220703_pre_ps
press75425963_pre_ss
prests84021273_prests
prexes154915953_prexes
preys105717793_pre_ys
prezes173614693_prezes
proas75028803_proa_s
prods85523553_pr_ods
pseuds944793_pseuds
rads56046613__r_ads
read55942533__read_
readd74617133__readd
readds84111643__readds
ready94821503__ready
reals55038653__reals
reams75729623__reams
reaps75626193__reaps
rears54739653__rears
redds74617833__redds
reds56042873__re_ds
reeds65430903__reeds
rends65129953__rends
repleads11357213repleads
reread71715433reread_
respread1135433respread_
retreads937823retreads
roads66523623__roads
salads75316963s_alads
saphead1357773saphead_
sarans64224433sar_ans
sardars83112903sardars
sards64736183sar__ds
sarees65329943sare_es
sarods74918573sar_ods
sarsars73512143sarsars
sayeds10469253saye_ds
scads85419963s__cads
scends95213003s_cends
scorepads1473023scorepads
scrags95713803scr_ags
scrams105216623scr_ams
scraps106017243scr_aps
screak125311063screa_k
screaky16436223screaky
scream104814253screa_m
screed95718933screed_
screens95212183screens
screes85023973scre_es
screws115513893scre_ws
scrods94111613scr_ods
seals54839703s__eals
seams75731663s__eams
sears54744913s__ears
seas45755273s__ea_s
seats54844343s__eats
seeds64330063s__eeds
sends65528243s__ends
seracs84418573ser_acs
serais64326133ser_ais
serdabs1035323serdabs
sered65737293sere_d_
sereins73716123sereins
serenade9218343serenade
serenades10217943serenades
serenes73222903serenes
seres55448893sere__s
serials73919753serials
servals103410753servals
shads95124483s__hads
sheafs124912883s_heafs
sheals94420643s_heals
shears93820903s_hears
sheas86331793s_hea_s
sheds96122703s_he_ds
shends105313773s_hends
sherds105614723s_herds
shields11538043shields
shmears1277073shmears
shred98125613shre_d_
shrewd136810783shrewd_
shrews129313923shre_ws
shrouds1136023shrouds
sirdars8228213sirdars
sired66134283sire_d_
sirees64624583sire_es
sirens65318153sire_ns
sires55945373sire__s
sirrahs10377303sirrahs
sirras63814863sirra_s
skeans104512913s_keans
sleds64418853s_le_ds
smears84714433s_mears
sneaks104312493s_neaks
sneaps84510863s_neaps
sneds65715353s_ne_ds
soras55041013sor_a_s
sords64527803sor__ds
sored66141783sore_d_
soreheads1346073soreheads
sorels63921163sore_ls
sores55454283sore__s
sowbreads1542853sowbreads
spade84423323sp__ade
spades94222583sp__ades
spado83713703sp__ado
spaed85522273spae_d_
spaes76029973sp__aes
spams94922193sp__ams
spans74528733sp__ans
spared95427493spare_d_
sparers94519613spare_rs
spares84834553spare__s
sparids103512123sparids
sparoids11218713sparoids
spars75431543sp__ars
spas67036723sp__a_s
spats75031383sp__ats
spays105520513sp__ays
speak114618673sp_ea_k
spean74620513sp_ea_n
spear75821063sp_ea_r
spearheads1642453spearheads
specks144312703sp_ecks
specs96916673sp_e_cs
sped76031493sp_e_d_
speed85526623sp_eed_
speedo94011993sp_eedo
speedos10298263speedos
speedreads1451873speedreads
speedy1218410793sp_eedy
speels85116393sp_eels
speers85019953sp_eers
speils84116223sp_eils
speirs85013233sp_eirs
speiss84311643sp_eiss
spells84617683sp_ells
spelts84614643sp_elts
spend85619333sp_end_
spendy124911143sp_endy
sperms102512603sp_erms
spews105015923sp_e_ws
sphenes123013163sphenes
spheres123114353spheres
spicas104715823spica_s
spied85427713spie_d_
spiels85317953spie_ls
spiers84421743spie_rs
spies76037623spie__s
spinals93911863spinals
spiraeas10286233spiraeas
spirals93212513spirals
spirea84015633spirea__
spired94921863spire_d_
spiremes12397623spiremes
spirems11499563spire_ms
spires84628113spire__s
spitals93011593spitals
splats84817303sp_lats
splays114910873sp_lays
spleens937103spleens
splents93912133splents
spored94821793spore_d_
spores84726613spore__s
sporrans1045523sporrans
sprag86418693spr_a_g
sprain83614863spr_ain
sprains93013593sprains
sprang95713523spr_ang
sprangs104610053sprangs
sprat76635973spr_a_t
sprawl11188063spr_awl
sprawls12176373sprawls
spray106720063spr_a_y
spreading1339653spreading
spree74830863spre__e
sprent84522383spre_nt
sprigs94814773spr_igs
springs104415923springs
sprints94113773sprints
sprites94220333sprites
sprits85122533spr_its
sprouts949983sprouts
spruces113810503spruces
sprues84515763spr_ues
sprugs94010173spr_ugs
spuds85113673sp__uds
spued84918473spue_d_
spues75025383spue__s
squads164410293s_quads
squeaks2034523squeaks
squeals1636513squeals
stead65520273s_tead_
steady103510203s_teady
steaks104415853s_teaks
steals64020063s_teals
steams84916903s_teams
steeds73814883s_teeds
strands83711953strands
straps87721783str_aps
strass67117223str_ass
straws98718673str_aws
strays96417933str_ays
streak104613623strea_k
streaky14447813streaky
stream84717293strea_m
streamy12509483streamy
streeks11378713streeks
streels73811343streels
streets73312623streets
streps86218063stre_ps
stress66616673stre_ss
strews96817103stre_ws
strouds837803strouds
subheads1496533subheads
superadd1246653superadd
superadds1346413superadds
supremes1238363supremes
supremos1245813supremos
surahs94515543sur_ahs
suras55336333sur_a_s
surds65624663sur__ds
surpass938283surpass
surras65919533surra_s
swears94114073s_wears
sweats94814613s_weats
syrens94911993syre_ns
thread105011093thread_
thready14435903thready
threaps12488643threaps
threats104311683threats
tread64821703_tread_
treats64821703_treats
trends75513543_trends
triads74513533_triads
unleads8228623unleads
unread73412673unread_
unready11215943unready
untreads936223untreads
upbears1195423upbears
upbeats1195743upbeats
upends9438763up_ends
upheaps1494233upheaps
upleaps1185233upleaps
uploads10266503uploads
upreach1444693upreach
uprear8168793uprea_r
uproars986453uproars
upsends10265293upsends
uptears9106453uptears
uptrends1142833uptrends
ureas55826013_urea_s
warheads1545853warheads
wreaks134711113_wreaks

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273976.92019368.1
3Display Results3973970.1432776.2
 (SQL Overall)1786913977.46923924.4
 
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.