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

273 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
spackles1631995(None) 
shackles173010591shackles
spackle15369571spackle_
spackled17297801spackled
sparkles143210491sparkles
speckles16268131speckles
cackles153717202_cackles
crackles164111272crackles
grackles15309182grackles
hackles162917062_hackles
mackles154415752_mackles
pickles153215442_pickles
shackle16409542shackle_
shackled18277602shackled
shackler17317972shackler
shacklers18336032shacklers
shackoes17367852shackoes
sickles133417542s_ickles
spaceless1335732spaceless
spaces104722632spac__es
spales84728102spa__les
spangles1138892spangles
sparkle133710212sparkle_
sparkled15317732sparkled
sparkler14317982sparkler
sparklers15315642sparklers
sparklet143110592sparklet
sparklets15275842sparklets
spatzles1935302spatzles
speckle15297552speckle_
speckled17255832speckled
spicules12219802spicules
stackless1555932stackless
stickles142512102stickles
suckles134516742s_uckles
tackles133816522_tackles
ackees124914573__ackees
ankles104818383__ankles
apaches143411833apac_hes
asparkle1443843asparkle_
backless162910633_backless
blackleg1734233blackleg
blacklegs1843913blacklegs
brickles162810283brickles
buckles153416093_buckles
cackle143416923_cackle_
cackled164613293_cackled
cackler153812573_cackler
cacklers163710703_cacklers
chuckles1936803chuckles
cockles153414643_cockles
crackle153611253crackle_
crackled17428863crackled
crankles143510153crankles
darkles124011933_darkles
deckles143312803_deckles
espanoles1143943espanoles
freckles17126383freckles
graciles112511613graciles
grackle14338893grackle_
hackees165014103_hackees
hackies163418243_hackies
hackle154916813_hackle_
hackled173312483_hackled
hackler163512353_hackler
hacklers173710303_hacklers
heckles163711383_heckles
huckles163612623_huckles
jacales16310323_jacales
jackies202912623_jackies
jackleg2135033_jackleg
jacklegs2233953_jacklegs
keckles12318763_keckles
knuckles1384453knuckles
mackle143716433_mackle_
mackled164111913_mackled
macles107023223_mac_les
macules114015133_macules
mickles153415003_mickles
muckles153413253_muckles
nickles133713823_nickles
oracles93212423orac_les
paces96741113_pac__es
packages17138733_packages
packed154822603_pack_ed
packer144223403_pack_er
packers153818893_packers
packet144726503_pack_et
packets155114773_packets
packly17228333_packl_y
packmen1746313_packmen
packness1636933_packness
packs135528933_pack__s
paddles113515643_paddles
padles95221123_pa_dles
pales75753803_pa__les
papules112411573_papules
parles86334403_pa_rles
paroles95025883_paroles
pickle144215653_pickle_
pickled164011883_pickled
prickles162511093prickles
rackle123917293_rackle_
rankles113114543_rankles
retackles1545363retackles
ruckles133414603_ruckles
sables85026693s_a_bles
saccules1237033saccules
sacked135525213s_ack_ed
sacker125124843s_ack_er
sackers133820223s_ackers
sacks114228873s_ack__s
sacques18106863s_acques
saddles95415743s_addles
sakes95540753s_a_k_es
sales56055593s_a__les
samples112815453s_amples
scabbles14167983scabbles
scales84529313s__cales
shacked174015393shack_ed
shackos16429023shack_os
shacks154817563shack__s
shakes135024593sha_k_es
shakoes144510023sha_koes
shales94731253sha__les
shambles15159043shambles
sickees134514213s_ickees
sickies133717503s_ickies
sickle124418323s_ickle_
sickled144713433s_ickled
sicklies14710013s_icklies
skatoles1236143skatoles
slacked143815453slack_ed
slacken13399933slack_en
slackens14367713slackens
slacker133915293slack_er
slackers143812743slackers
slackest14289393slack_est
slackly1635263slackl_y
slackness1535433slackness
slacks124416533slack__s
slakes104021883sla_k_es
smacked163710993smack_ed
smacker153410583smack_er
smackers16318713smackers
smacks144112323smack__s
snacked144013113snack_ed
snacker133112603snack_er
snackers143010223snackers
snacks124514553snack__s
snaffles14246043snaffles
snakes103919603sna_k_es
sockless14267793s_ockless
socles8418453s_oc_les
space95325673spac__e_
spaced114517253spac__ed
spacemen1445413spacemen
spacer104917793spac__er
spacers113813873spac_ers
spacey136212533spac__ey
spacier114011633spac_ier
spaciest122310893spac_iest
spaciness1337083spaciness
spacings13287043spacings
spacious1237813spacious
spackling18266503spackling
spades94222583spa__des
spadices1336093spadices
spadilles1244993spadilles
spadixes1834113spadixes
spadones1137253spadones
spaes76029973spa___es
spaetzles2042153spaetzles
spahees1238263spa_hees
spails84817823spa_il_s
spake114322743spa_k_e_
spale74929213spa__le_
spalled103113133spa_lled
spaller92713473spa_ller
spallers102910733spa_llers
spalls84217343spa__lls
spanceled1443693spanceled
spancels1245273spancel_s
spangle1038403spangle_
spangled1236153spangled
spaniels1045963spaniels
spanked143111733spank_ed
spanker133612353spank_er
spankers14369863spankers
spanks124514123spank__s
spanless10247363spa_nless
spansules1143613spansules
sparables13167163sparables
spares84834553spa__res
sparges104016343spa_rges
sparked143513143spark_ed
sparker133914363spark_er
sparkers144111313sparkers
sparkier14298033sparkier
sparkiest15188093sparkiest
sparklier1554363sparklier
sparkliest1644573sparkliest
sparkly16348133sparkl_y
sparks124616363spark__s
spates85028173spa__tes
spathes125116533spa_thes
spatulas1045473spatulas
spatzle1834583spatzle_
spavies123012943spa_vies
spazzes1735263spa_zzes
species11314133spec_ies
specked16329013speck_ed
specks144312703speck__s
spectres12268683spectres
spiceless1335923spiceless
spices104326033spic__es
spicks144814993spick__s
spicule11269933spicule_
spikes124520713sp_ik_es
spiles84227913sp__iles
spindles112710353spindles
spinules10249333spinules
spiracles1345663spirac_les
spittles1038333spittles
splakes1349673splak_es
spokes124417213sp_ok_es
sporules1037703sporules
spraddles13194283spraddles
sprattles1174883sprattles
sprinkles1534923sprinkles
spunkies14227583spunkies
spurtles1037783spurtles
stabiles10311403stabiles
stables93219073sta_bles
stacked143416123stack_ed
stacker134416263stack_er
stackers143413563stackers
stacks124317263stack__s
stackups1643313stackups
stactes91914633stac_tes
staddles10258693staddles
stakes103927293sta_k_es
stales65538293sta__les
stalkless1333723stalkless
staples93617213sta_ples
startles82111963startles
stickies142211973stickies
stickle132410973stickle_
stickled15298973stickled
stickler14259573stickler
sticklers15227393sticklers
strickles1567813strickles
suckle124015963s_uckle_
suckled144212513s_uckled
suckler133413093s_uckler
sucklers14379963s_ucklers
suckless14288823s_uckless
swacked173110523swack_ed
swaddles13296453swaddles
swales93920763swa__les
tackle123815733_tackle_
tackled143913183_tackled
tackler134013323_tackler
tacklers143010773_tacklers
tackless14419483_tackless
tickles133416853_tickles
trachles13311753trachles
trackless15246723trackless
trickles143013763trickles
truckles14319383truckles
unshackles1941993unshackles
upscales12155993upscales
wackes154717713_wack_es

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622737.17320376.7
3Display Results2732730.1062575.5
 (SQL Overall)1786912737.45223978.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.