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

279 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
shackle1640954(None) 
hackle154916811_hackle
shackled18277591shackled
shackler17317971shackler
shackles173010591shackles
spackle15369561spackle
cackle143416922_cackle
chuckle1836442chuckle
crackle153611252crackle
grackle14338892grackle
hackee154921832_hackee
hackie154615622_hackie
hackled173312482_hackled
hackler163512352_hackler
hackles162917062_hackles
hackly18298732_hackly
heckle153112092_heckle
huckle153913072_huckle
mackle143716432_mackle
rackle123917292_rackle
shack145321752shack__
shacked174015392shacked
shacklers18336032shacklers
shacko153810112shack_o
shackoes17367852shackoes
shackos16429022shackos
shacks154817562shack_s
shake124726402sha_k_e
shale85332832sha__le
shamble14149262shamble
sickle124418322s_ickle
slackly1635262slackly
spackled17297792spackled
spackles16319942spackles
sparkle133710202sparkle
speckle15297552speckle
stickle132410972stickle
suckle124015962s_uckle
tackle123815732_tackle
unshackle1842762unshackle
ackee115825363__ackee
ankle95220253__ankle
ashcake1663373ashcak_e
asparkle1443833asparkle
blackleg1734233blackleg
blackly1835253blackly
brickle15279933brickle
buckle144815193_buckle
cackled164613293_cackled
cackler153812573_cackler
cackles153717203_cackles
chickee183111553chickee
chicle134312543chic_le
chuckled2045163chuckled
chuckler1935553chuckler
chuckles1936803chuckles
cockle143913573_cockle
crackled17428863crackled
crackles164111273crackles
crackly18397703crackly
crankle133610063crankle
darkle113813943_darkle
deckle1312012453_deckle
facile112514883_facile
fickle153912973_fickle
freckle16106643freckle
gracile102512603gracile
grackles15309183grackles
habile11515213_habile
hack135134543_hack__
hackable1937473_hackable
hacked164923513_hacked
hackees165014103_hackees
hacker154822693_hacker
hackies163418243_hackies
hacklers173710303_hacklers
hacklier1737133_hacklier
hackmen1836713_hackmen
hackney1935123_hackney
hacks144928713_hack_s
haggle113511983_haggle
hake115637843_ha_k_e
hale76052833_ha__le
handle104219293_handle
hankie133915713_hankie
hantle94318203_hantle
haole84820083_ha_ole
hassle93711593_hassle
hawkie163810093_hawkie
heckled17318463_heckled
heckler16278573_heckler
heckles163711383_heckles
hickie153812473_hickie
huckles163612623_huckles
jackleg2135033_jackleg
keckle11359423_keckle
knuckle1254233knuckle
mackled164111913_mackled
mackles154415753_mackles
macle96127003_mac_le
macule104115273_macule
mickle143715133_mickle
muckle143413583_muckle
nickle123814483_nickle
oracle84313293orac_le
packly17228333_packly
pickle144215653_pickle
prickle153611013prickle
ramshackle215923ramshackle
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
shacking184014083shacking
shackling19286173shackling
shade95125583sha__de
shadfly1733783shadfly
shadily1437723shadily
shakable17177683shakable
shaken134113613sha_ken
shaker134319463sha_ker
shakes135024593sha_kes
shakier143411153sha_kier
shakily1736903shakily
shako125516083sha_k_o
shakoes144510013sha_koes
shakos134912183sha_kos
shaky154616843sha_k_y
shaled105023953sha__led
shales94731253sha__les
shaley123714993sha__ley
shall85024053sha__ll
shalt85534483sha__lt
shaly114322863sha__ly
shamable15168793shamable
shambled16156153shambled
shambles15159043shambles
shame105726703sha__me
shank125422193shank__
shanked153212123shanked
shanks135315583shank_s
shapable15197803shapable
shape105125113sha__pe
shapely1536893shapely
sharable131910693sharable
share86437083sha__re
shark126225023shark__
sharked153613903sharked
sharker144313813sharker
sharklike1543923sharklike
sharks135019723shark_s
sharpie1238383sharpie
sharply15406833sharply
shaul85418103sha_ul_
shauled1148793sha_uled
shauls94913113sha_uls
shavable16177273shavable
shave114425893sha__ve
shavie124312413sha_vie
shawl116217573sha_wl_
shawled1437773sha_wled
shawls125411973sha_wls
shekel1338383sh_ekel
shicker163914823shicker
shicksa1634103shicksa
shikse1386073sh_ikse
shingle117711273shingle
shock144917023shock__
shockable2044703shockable
shocked174611803shocked
shocker163411423shocker
shocks154414573shock_s
shrike134513243shrik_e
shuck144314533shuck__
shucked17389833shucked
shucker163710103shucker
shucks154010413shuck_s
shuffle16276913shuffle
shuttle1046093shuttle
sickee124622223s_ickee
sickie123715743s_ickie
sickled144713433s_ickled
sickles133417543s_ickles
sickly153110483s_ickly
skatole1135683skatole
slack115021763slack__
slacked143815453slacked
slacken13399933slacken
slacker133915293slacker
slacks124416533slack_s
slake93724053sla_k_e
slickly1635853slickly
smack134615453smack__
smacked163710993smacked
smacker153410583smacker
smacks144112323smack_s
snack114718063snack__
snacked144013113snacked
snacker133112603snacker
snacks124514553snack_s
snaffle13216243snaffle
snake94821113sna_k_e
socle7419573s_oc_le
space95325673spac__e
spake114322743spa_k_e
spale74929213spa__le
spangle1038403spangle
sparkled15317723sparkled
sparkler14317973sparkler
sparkles143210483sparkles
sparklet143110583sparklet
sparkly16348123sparkly
spatzle1834573spatzle
speckled17255823speckled
speckles16268133speckles
spicule11269933spicule
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
tackled143913183_tackled
tackler134013323_tackler
tackles133816523_tackles
thack144915173thack__
thacked173810203thacked
thacks154311923thack_s
thickly19415573thickly
tickle124616743_tickle
trachle12311853trachle
trickle133613443trickle
truckle13358863truckle
unshackled2042243unshackled
unshackles1941993unshackles
wacke145918623_wack_e
whack174813023whack__
whacked20458623whacked
whacker19368503whacker
whackier2044673whackier
whacko18477033whack_o
whackos19375263whackos
whacks184610483whack_s
whacky21556493whack_y
whale115517433wha__le

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.1731032896.0
2DLD Change Limit1340272797.42018062.9
3Display Results2792790.1102536.4
 (SQL Overall)1786912797.70323197.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.