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

270 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
spackle1536957(None) 
shackle16409541shackle
spackled17297801spackled
spackles16319951spackles
sparkle133710211sparkle
speckle15297551speckle
asparkle1443842asparkle
cackle143416922_cackle
crackle153611252crackle
grackle14338892grackle
hackle154916812_hackle
mackle143716432_mackle
packly17228332_packly
pickle144215652_pickle
rackle123917292_rackle
shackled18277602shackled
shackler17317972shackler
shackles173010592shackles
sickle124418322s_ickle
slackly1635262slackly
space95325672spac__e
spake114322742spa_k_e
spale74929212spa__le
spangle1038402spangle
sparkled15317732sparkled
sparkler14317982sparkler
sparkles143210492sparkles
sparklet143110592sparklet
sparkly16348132sparkly
spatzle1834582spatzle
speckled17255832speckled
speckles16268132speckles
spicule11269932spicule
stickle132410972stickle
suckle124015962s_uckle
tackle123815732_tackle
ackee115825373__ackee
ankle95220253__ankle
apace94718383apac__e
apache134210773apac_he
blackleg1734233blackleg
blackly1835253blackly
brickle15279933brickle
buckle144815193_buckle
cackled164613303_cackled
cackler153812573_cackler
cackles153717203_cackles
chuckle1836443chuckle
cockle143913573_cockle
crackled17428863crackled
crackles164111273crackles
crackly18397703crackly
crankle133610063crankle
darkle113813943_darkle
deckle1312012453_deckle
facile112514883_facile
fickle153912973_fickle
freckle16106643freckle
gracile102512603gracile
grackles15309183grackles
hackee154921833_hackee
hackie154615623_hackie
hackled173312493_hackled
hackler163512353_hackler
hackles162917063_hackles
hackly18298733_hackly
heckle153112093_heckle
huckle153913073_huckle
jackleg2135043_jackleg
keckle11359423_keckle
knuckle1254233knuckle
mackled164111923_mackled
mackles154415753_mackles
macle96127003_mac_le
macule104115273_macule
mickle143715133_mickle
muckle143413583_muckle
nickle123814483_nickle
oracle84313293orac_le
pace86345773_pac__e
pack125535443_pack__
packable1838633_packable
package16128013_package
packed154822603_packed
packer144223403_packer
packet144726503_packet
packmen1746313_packmen
packs135528933_pack_s
paddle104615143_paddle
padle84522343_pa_dle
pale66055013_pa__le
papule102212133_papule
parle75836163_pa_rle
parole84425253_parole
pickled164011883_pickled
pickles153215443_pickles
prickle153611013prickle
rankle103414883_rankle
retackle1445043retackle
ruckle124414583_ruckle
sable74732163s_a_ble
saccule1136743saccule
sack105337313s_ack__
sacked135525213s_acked
sacker125124843s_acker
sacklike1337303s_acklike
sacks114228873s_ack_s
sacque17107113s_acque
saddle83915493s_addle
sake85244963s_a_k_e
sale44959703s_a__le
sample104215013s_ample
scabble13168653scabble
scale74629143s__cale
shack145321753shack__
shacked174015393shacked
shacklers18336033shacklers
shacko153810113shack_o
shackoes17367853shackoes
shackos16429023shackos
shacks154817563shack_s
shake124726403sha_k_e
shale85332833sha__le
shamble14149263shamble
sickee124622223s_ickee
sickie123715743s_ickie
sickled144713433s_ickled
sickles133417543s_ickles
sickly153110483s_ickly
skatole1135693skatole
slack115021763slack__
slacked143815453slacked
slacken13399933slacken
slacker133915293slacker
slacks124416533slack_s
slake93724053sla_k_e
slickly1635853slickly
smack134615453smack__
smacked163710993smacked
smacker153410583smacker
smacks144112323smack_s
snack114718063snack__
snacked144013113snacked
snacker133112603snacker
snacks124514553snack_s
snaffle13216253snaffle
snake94821113sna_k_e
socle7419573s_oc_le
spaced114517253spac_ed
spaceless1335733spaceless
spacemen1445413spacemen
spacer104917793spac_er
spacers113813873spacers
spaces104722633spac_es
spacey136212533spac_ey
spacial1138763spacial
spacier114011633spacier
spacing123614493spacing
spackling18266503spackling
spacy125415623spac__y
spade84423323spa__de
spadille1145193spadille
spae65034323spa___e
spaetzle1942243spaetzle
spahee11313443spa_hee
spail74921553spa_il_
spails84817823spa_ils
spales84728103spa__les
spall74919303spa__ll
spalled103113133spa_lled
spaller92713473spa_ller
spalls84217343spa_lls
spancel1147363spancel_
spanceled1443693spanceled
spancels1245273spancels
spangled1236153spangled
spangles1138893spangles
spangly1336473spangly
spaniel948923spaniel
spank115919573spank__
spanked143111733spanked
spanker133612353spanker
spanks124514123spank_s
spansule1043623spansule
sparable121611983sparable
spare75135563spa__re
sparely123410673sparely
sparge94216053spa_rge
spark114920893spark__
sparked143513143sparked
sparker133914363sparker
sparkier14298033sparkier
sparkily1735023sparkily
sparklers15315643sparklers
sparklets15275843sparklets
sparklier1554363sparklier
sparks124616363spark_s
sparky154511523spark_y
sparse84516343spa_rse
spate74731583spa__te
spathe115115693spa_the
spatula935893spatula
spatzles1935303spatzles
spavie113611383spa_vie
specie10412223spec_ie
speck135115653speck__
specked16329013specked
specks144312703speck_s
spectre11297773spectre
specula11187413specula
spicae104313703spic_ae
spicate113214193spicate
spice95528813spic__e
spicily1438653spicily
spick134519073spick__
spicks144814993spick_s
spicula11259293spicula
spiculae12218603spiculae
spicules12219803spicules
spike114922843sp_ik_e
spile75230083sp__ile
spindle103210093spindle
spinule9299993spinule
spiracle1255803spirac_le
spittle937923spittle
splake1259783splak_e
spoke114818663sp_ok_e
sporule937273sporule
spraddle12194163spraddle
sprattle1054763sprattle
sprinkle1434893sprinkle
spunkie13215303spunkie
spurtle937453spurtle
stabile9312063stabile
stable83921643sta_ble
stack114421693stack__
stackable1735993stackable
stacked143416123stacked
stacker134416263stacker
stackless1555933stackless
stacks124317263stack_s
stackup1533743stackup
stacte82113913stac_te
staddle9288093staddle
stake95927533sta_k_e
stale55637103sta__le
staple84415823sta_ple
starkly14277033starkly
startle72511123startle
stickled15298973stickled
stickler14259573stickler
stickles142512103stickles
strickle1467793strickle
suable83920553sua_ble
suckled144212513s_uckled
suckler133413093s_uckler
suckles134516743s_uckles
swacked173110523swacked
swaddle12276743swaddle
swale85221593swa__le
tackled143913193_tackled
tackler134013323_tackler
tackles133816523_tackles
tickle124616743_tickle
trachle12311853trachle
trickle133613443trickle
truckle13358863truckle
unshackle1842763unshackle
upscale11136323upscale
wacke145918623_wack_e

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 Limit1340272706.89019452.4
3Display Results2702700.0962812.5
 (SQL Overall)1786912707.39224173.6
 
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.