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

268 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
sparkled1531773(None) 
spackled17297801spackled
sparked143513141spark_ed
sparkle133710211sparkle_
sparkler14317981sparkler
sparkles143210491sparkles
sparklet143110591sparklet
asparkle1443842asparkle_
darkled13378722_darkled
parked134425142_park_ed
parled94626292_par_led
paroled104217632_paroled
shackled18277602shackled
sharked153613912shark_ed
snarled83612362snar_led
spackle15369572spackle_
spackles16319952spackles
spalled103113132spa_lled
spangled1236152spangled
spanked143111732spank_ed
spared95427492spar__ed
sparged113512762spar_ged
sparker133914362spark_er
sparkier14298032sparkier
sparklers15315642sparklers
sparklets15275842sparklets
sparklier1554362sparklier
sparkly16348132sparkl_y
sparred104512862spar_red
speckled17255832speckled
spiraled1137732spiraled
sprawled1434522sprawled
startled9208562startled
ankled114313483__ankled
appareled1442893appareled
argled85314553__argled
ariled75620323__ariled
barked135027313_bark_ed
cackled164613303_cackled
carked134024823_cark_ed
caroled103717693_caroled
charked174814013chark_ed
crackled17428863crackled
crankled15408153crankled
darked123919633_dark_ed
darkle113813943_darkle_
darkles124011933_darkles
dartled9409853_dartled
garbled114512803_garbled
gargled104210673_gargled
gnarled9287723gnar_led
hackled173312493_hackled
harked145422553_hark_ed
imparked17264863impark_ed
larked114519473_lark_ed
mackled164111923_mackled
marbled123212113_marbled
marked133921623_mark_ed
marled95523163_mar_led
narked114116743_nark_ed
outsparkled1891593outsparkled
packed154822603_pack_ed
paddled123612023_paddled
paiked135113433_paik_ed
paled85538723_pa__led
palled94625163_pa_lled
paneled10612573_paneled
paraded114014263_paraded
parceled1338343_parceled
parched154013693_parched
pared86946763_par__ed
parged104922043_par_ged
parkade1437583_parkade
parker124121373_park_er
parkland1545373_parkland
parle75836163_par_le_
parles86334403_par_les
parley116718363_par_ley
parole84425253_parole_
parolee94119643_parolee
paroles95025883_paroles
parred95024073_par_red
parried103615723_parried
parsed96323893_par_sed
parsley1247803_parsley
parslied1137823_parslied
parted94228683_par_ted
partied103516553_partied
partlet92720363_partlet
pearled10411553pear_led
periled10316323_periled
perked134617693_perk_ed
pickled164011883_pickled
porked134717623_pork_ed
purfled13248733_purfled
purled94520753_pur_led
purpled12299783_purpled
rankled123910653_rankled
reparked15208923repark_ed
sacked135525213s_ack_ed
saddled103112033s_addled
sailed74327763s_a_iled
sampled123410793s_ampled
sarkier113413313s_arkier
scabbled15156303scabbled
scaled94822443sca__led
scared95227293scar__ed
scarfed134711183scar_fed
scarlet91516943scar_let
scarped124314403scar_ped
scarphed1635443scarphed
scarred104512633scar_red
scarted104816123scar_ted
scrawled1445923scrawled
sealed74328363sea__led
searched14209253searched
seared75232843sear__ed
sepaled10510593sepa__led
sepalled1156903sepa_lled
separated1237713separated
shacked174015393shack_ed
shackle16409543shackle_
shackler17317973shackler
shackles173010593shackles
shaled105023953sha__led
shambled16156153shambled
shanked153212123shank_ed
shared105829063shar__ed
sharker144313813shark_er
sharped134112053shar_ped
shauled1148793sha_uled
shawled1437773sha_wled
shirked153710463shirk_ed
sickled144713433s_ickled
skanked11338103skank_ed
skirled12348183skir_led
slacked143815453slack_ed
slaked114318273sla_k_ed
smacked163710993smack_ed
smarted105012613smar_ted
smerked14327283smerk_ed
smirked14307233smirk_ed
snacked144013113snack_ed
snaffled15285213snaffled
snailed83811923sna_iled
snaked115017593sna_k_ed
snared74824553snar__ed
snarfed11378753snar_fed
snarkier12336513snarkier
snarler73610633snar_ler
snorkeled1442883snorkeled
soaked114717593soa_k_ed
soared74324293soar__ed
spaced114517253spa__ced
spaded103816753spa__ded
spaed85522273spa___ed
spake114322743spa_k_e_
spale74929213spa__le_
spales84728103spa__les
spaller92713473spa_ller
spammed14348523spa_mmed
spanceled1443693spanceled
spangle1038403spangle_
spangles1138893spangles
spanker133612353spank_er
spanned104111223spa_nned
sparable121611983sparable_
sparables13167163sparables
spare75135563spar__e_
sparely123410673sparel_y
sparer84524963spar__er
spares84834553spar__es
sparge94216053spar_ge_
sparger103613083spar_ger
sparges104016343spar_ges
sparid94016933spar__id
spark114920893spark___
sparkers144111313sparkers
sparkiest15188093sparkiest
sparkily1735023sparkily
sparking152812543sparking
sparkish17276973sparkish
sparkliest1644573sparkliest
sparkling16226353sparkling
sparkplug1881203sparkplug
sparks124616363spark__s
sparky154511523spark__y
sparoid102311543spar_oid
sparrier10329143sparrier
sparse84516343spar_se_
sparsely1335123sparsely
sparser94311483spar_ser
spasmed12296993spa_smed
spathed134013183spa_thed
spatted104014143spa_tted
spatzle1834583spatzle_
spatzles1935303spatzles
spavined1434333spavined
spawned13316803spa_wned
spayed124213613spa__yed
speared104314423spear__ed
specked16329013speck_ed
speckle15297553speckle_
speckles16268133speckles
speeled103712453sp_eeled
speiled104412123sp_eiled
spelled103714743sp_elled
spieled104811883sp_ieled
spiked134915553sp_ik_ed
spiled94621993sp__iled
spilled103613623sp_illed
spindled12287643spindled
spiralled1244403spiralled
spired94921863spir__ed
spirited1148973spirited
spirted103913073spir_ted
spoiled104811353sp_oiled
spoked134413893sp_ok_ed
spooked144510473spook_ed
spooled104613523sp_ooled
spored94821793spor__ed
sported104015433spor_ted
sporule937273sporule_
sporules1037703sporules
spraddled14203463spraddled
sprained1138433sprained
sprattled1263313sprattled
sprawler1334653sprawler
sprayed13398903sp_rayed
sprinkled1633713sprinkled
spruced12307533sp_ruced
spunked14307783spunk_ed
spurned10339263spur_ned
spurred103610623spur_red
spurted103111973spur_ted
spurtle937453spurtle_
spurtles1037783spurtles
stabled103514953sta_bled
stacked143416123stack_ed
staked114621943sta_k_ed
staled74728103sta__led
stalked123811173stalk_ed
stalled83515693sta_lled
stapled103613703sta_pled
starched14199313starched
stared75429873star__ed
starker114114693stark_er
starkly14277033starkl_y
starlet71620123star_let
starred85013453star_red
started84217323star_ted
startle72511123startle_
startler8248793startler
startles82111963startles
starved114911573star_ved
stickled15298973stickled
straked125415343strak_ed
suckled144212513s_uckled
swacked173110523swack_ed
swaddled14254963swaddled
swanked15359543swank_ed
swarded1238153swar_ded
swarmed1367483swar_med
swirled11308223swir_led
tackled143913193_tackled
warbled133212163_warbled
warked144421213_wark_ed
warsled112910443_warsled

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622687.84318636.0
3Display Results2682680.0932881.7
 (SQL Overall)1786912688.37221343.9
 
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.