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

262 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
sparkly1634813(None) 
sparely123410671sparely
sparkily1735021sparkily
sparkle133710211sparkle
sparky154511521spark_y
starkly14277031starkly
asparkle1443842asparkle
darkly145411072_darkly
packly17228332_packly
partly116315472_partly
sarky125521782s_ark_y
scarily12311702scarily
sharply15406832sharply
slackly1635262slackly
smartly12497432smartly
snarkily1534582snarkily
snarky134210842snark_y
snarly93815002snar_ly
spackle15369572spackle
spangly1336472spangly
spark114920892spark__
sparked143513142sparked
sparker133914362sparker
sparkled15317732sparkled
sparkler14317982sparkler
sparkles143210492sparkles
sparklet143110592sparklet
sparks124616362spark_s
sparry115111302spar_ry
sparsely1335122sparsely
sprawly15166042sprawly
spryly1435512sp_ryly
barely114716793_barely
barfly14339653_barfly
barky145721613_bark_y
blackly1835253blackly
blankly1634263blankly
charily15310283charily
clerkly1643573clerkly
crackly18397703crackly
crankly16358123crankly
dankly14419463_dankly
darkey145212423_darkey
darkle113813943_darkle
darky136018833_dark_y
dearly104615323dear_ly
early85324123_ear_ly
eparchy17204753eparchy
frankly17315633frankly
gnarly104610383gnar_ly
hackly18298733_hackly
hardly135112833_hardly
hoarily1338973hoarily
lankly13439623_lankly
larky125218873_lark_y
marbly134111933_marbly
marly106925613_mar_ly
murkly15368303_murkly
narky126017803_nark_y
nearly94813733near_ly
palely11311933_palely
pally105727123_pa_lly
paly95835533_pa__ly
pardy115523953_par_dy
parity114719873_parity
park105237493_park__
parka115120883_park_a
parkas125018023_parkas
parked134425143_parked
parker124121373_parker
parks116134463_park_s
parkway1934553_parkway
parlay113713993_parlay
parle75836163_par_le
parley116718363_parley
parody12410093_parody
parol74826273_parol_
parole84425253_parole
parols84722613_parols
parry105323753_par_ry
parsley1247803_parsley
party106630613_par_ty
patly105020583_pa_tly
pawkily1934203_pawkily
pawky173810153_pawk_y
pearly116414843pear_ly
peartly1267453peartly
perkily1637813_perkily
perky145319483_perk_y
pertly115312553_pertly
pinkly155012243_pinkly
porky145019333_pork_y
portly114713403_portly
purely114013633_purely
purply13369053_purply
rankly133910453_rankly
rarely93513653_rarely
sadly94519123s_a_dly
safely12249393s_afely
sagely102811383s_agely
sally85129713s_a_lly
sanely93114613s_anely
sappily1437163sappily
sark84938973s_ark__
sarks96632463s_ark_s
sawfly1535133s_awfly
scaly104718723sca__ly
scantly12419553scantly
scarcely1534313scarcely
scarey115016983scar_ey
scarify1537443scarify
scarry116311183scar_ry
scary105222593scar__y
scrawly15197193scrawly
separably1655773separably
shackle16409543shackle
shadfly1733783shadfly
shadily1437723shadily
shakily1736903shakily
shaky154616843sha_k_y
shaly114322863sha__ly
shapely1536893shapely
shark126225023shark__
sharked153613913sharked
sharker144313813sharker
sharks135019723shark_s
sharny124711833shar_ny
sharpy145211033shar_py
shortly13387573shortly
sickly153110483s_ickly
skanky12476963skank_y
slantly10399323slantly
sleekly14325193sleekly
slickly1635853slickly
smarmily1543523smarmily
smarmy13629353smar_my
smarty115013793smar_ty
smirkily1753333smirkily
smirky15406943smirk_y
snakey135011273sna_key
snakily1436913snakily
snaky125113913sna_k_y
snark95419943snark__
snarks104815733snark_s
snarl54921083snar_l_
snarls64016873snar_ls
soapily1237963soapily
sorely94618013s_orely
sorrily1039833sorrily
sourly93612213sour_ly
spacey136212533spa_cey
spackled17297803spackled
spackles16319953spackles
spacy125415623spa__cy
spail74921553spa_il_
spails84817823spa_ils
spake114322743spa_k_e
spale74929213spa__le
spall74919303spa__ll
spalls84217343spa_lls
spangle1038403spangle
spank115919573spank__
spanked143111733spanked
spanker133612353spanker
spanks124514123spank_s
spar65433303spar___
sparable121611983sparable
spare75135563spar__e
spared95427493spar_ed
sparer84524963spar_er
sparers94519613sparers
spares84834553spar_es
sparest94616423sparest
sparge94216053spar_ge
sparged113512763sparged
sparger103613083sparger
sparges104016343sparges
sparid94016933spar_id
sparids103512123sparids
sparing104823873sparing
sparingly1537283sparingly
sparkers144111313sparkers
sparkier14298033sparkier
sparking152812543sparking
sparkish17276973sparkish
sparklers15315643sparklers
sparklets15275843sparklets
sparklier1554363sparklier
sparkling16226353sparkling
sparkplug1881203sparkplug
sparoid102311543sparoid
sparred104512863sparred
sparrow1234263sparrow
spars75431543spar__s
sparse84516343spar_se
sparser94311483sparser
sparsity1345463sparsity
spartan948333spartan
spatula935893spatula
spatzle1834583spatzle
spay96631663spa___y
speckle15297553speckle
spicily1438653spicily
spikey155411333sp_ikey
spikily1635873spikily
spiky146014113sp_ik_y
spindly13257383spindly
spiral83715343spiral_
spirally1348023spirally
spirals93212513spirals
spirula9257703spirula
spiry105017353spir__y
spookily1744173spookily
spooky15418093spook_y
sporal82915453sporal_
sportily1337733sportily
sporty115112493spor_ty
sporule937273sporule
sprawl11188063sprawl_
sprawls12176373sprawls
spray106720063sp_r_ay
sprucy13356323sp_rucy
spry96819123sp_r__y
spunkily1733773spunkily
spunky15427163spunk_y
spurrey12307813spurrey
spurry11429123spur_ry
spurtle937453spurtle
squarely2045353squarely
stably113314123sta_bly
stagily1139053stagily
staidly1136683staidly
stalely1039213stalely
stalkily1534823stalkily
stalky13499303stalk_y
starchy15286743starchy
stark95425623stark__
starker114114693starker
starry94911673star_ry
startle72511123startle
startsy10536703startsy
stately10310223stately
sternly1037853sternly
suably112814533sua_bly
suavely1376493suavely
superbly1546983superbly
surely93816463s_urely
surly85124433s_ur_ly
swankily1833833swankily
swanky16447973swank_y
swarthy16466373swarthy
swarty125812383swar_ty
swirly12439253swir_ly
tartly96014023_tartly
tearily10311153tearily
upwardly1742793upwardly
warily122915093_warily
warmly14228063_warmly
weakly1636483wea_kly
wearily1338783wearily
yarely122810303_yarely
yearly125210273year_ly

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.513348325.5
2DLD Change Limit1340272627.15618729.3
3Display Results2622620.0932817.2
 (SQL Overall)1786912627.76223021.3
 
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.