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

313 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
stickle13241097(None) 
sickle124418321s_ickle
stickled15298971stickled
stickler14259571stickler
stickles142512101stickles
strickle1467791strickle
tickle124616741_tickle
brickle15279932brickle
fickle153912972_fickle
mickle143715132_mickle
nickle123814482_nickle
pickle144215652_pickle
prickle153611012prickle
shackle16409542shackle
sickee124622222s_ickee
sickie123715742s_ickie
sickled144713432s_ickled
sickles133417542s_ickles
sickly153110482s_ickly
slickly1635852slickly
spackle15369572spackle
speckle15297552speckle
spicule11269932spicule
stick115121562stick__
stickable1745542stickable
sticked144114632sticked
sticker133515882sticker
stickier14229762stickier
stickies142211972stickies
stickily1736082stickily
stickit1339462stickit
sticklers15227392sticklers
sticklike1444002sticklike
stickmen1634542stickmen
sticks125118612stick_s
stickum1534822stickum
stickup1533852stickup
sticky154711342stick_y
stifle93611902sti_fle
stile54931572sti__le
stipple1146622stipple
stipule936722stipule
strickled1665832strickled
strickles1567812strickles
suckle124015962s_uckle
tackle123815732_tackle
tickled144313132_tickled
tickler133612652_tickler
tickles133416852_tickles
tinkle103714452_tinkle
trickle133613442trickle
article9310923artic_le
atingle848253atingle
brickles162810283brickles
bricole112810493bricole
buckle144815193_buckle
cackle143416923_cackle
chickee183111553chickee
chicle134312543chic_le
chuckle1836443chuckle
cicale10314503_cicale
cockle143913573_cockle
crackle153611253crackle
crinkle13359413crinkle
cuticle1138233cutic_le
deckle1312012453_deckle
dickie133913113_dickie
fickler16348423_fickler
fickly18318533_fickly
freckle16106643freckle
grackle14338893grackle
hackle154916813_hackle
heckle153112093_heckle
hickie153812473_hickie
huckle153913073_huckle
icicle1036583icic_le
inkle94515833__inkle
keckle11359423_keckle
knuckle1254233knuckle
mackle143716433_mackle
meikle1236653mei_kle
mickler153310233_mickler
mickles153415003_mickles
muckle143413583_muckle
nickel123811343_nickel
nickled144010443_nickled
nickles133713823_nickles
ossicle944483ossic_le
ostiole739013osti_ole
pickled164011883_pickled
pickles153215443_pickles
prickled17358073prickled
prickles162511093prickles
prickly18367893prickly
quickie2235513quickie
quickly2534073quickly
rackle123917293_rackle
retackle1445043retackle
reticle94112623retic_le
reticule1049303reticule
ruckle124414583_ruckle
saccule1136743saccule
saice75424053saic__e
sanicle91210263sanic_le
satiable10310733satiable
scale74629143s__cale
seiche11811833seic_he
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
shicker163914823shicker
shicksa1634103shicksa
shikse1386073shi_kse
shingle117711283shingle
shtick15308023shtick__
shtickier1843163shtickier
shticks16356963shtick_s
shticky19344473shtick_y
sice65545593s_ic__e
sick106435573s_ick__
sickbed16396823s_ickbed
sicked134524403s_icked
sickees134514213s_ickees
sicken124615253s_icken
sicker124023903s_icker
sickies133717503s_ickies
sicklied1546583s_icklied
sicklier1457213s_icklier
sicklies14710013s_icklies
sicko115315393s_ick_o
sickos125112033s_ickos
sicks115127623s_ick_s
sidle65124033s_i_dle
sike87138783s_i_k_e
silicle937753silic_le
silkie103313403s_ilkie
simile83115633s_imile
simple104315173s_imple
single74520603s_ingle
sizzle14309613s_izzle
skiable1338883skiable
skiffle17225203skiffle
skittle1135533skittle
slackly1635263slackly
slice74925823slic__e
slick115520523slick__
slicked144413843slicked
slicken13309293slicken
slicker133314533slicker
slicks124816113slick_s
smile74823923smi__le
snick114416013snick__
snicked143811633snicked
snicker133012673snicker
snicks124312473snick_s
sniffle13287653sniffle
sniggle9316833sniggle
socle7419573s_oc_le
spackled17297803spackled
spackles16319953spackles
sparkle133710213sparkle
speckled17255833speckled
speckles16268133speckles
spicae104313703spic_ae
spicate113214193spicate
spice95528813spic__e
spicily1438653spicily
spick134519073spick__
spicks144814993spick_s
spicula11259293spicula
spiculae12218603spiculae
spicules12219803spicules
spike114922843spi_k_e
spile75230083spi__le
spindle103210093spindle
spinule9299993spinule
spittle937923spittle
sprinkle1434893sprinkle
stabile9312063stabile
stable83921643st_able
stack114421693stack__
stackable1735993stackable
stacked143416123stacked
stacker134416263stacker
stackless1555933stackless
stacks124317263stack_s
stackup1533743stackup
stacte82113913stac_te
staddle9288093staddle
stake95927533st_ak_e
stale55637103st__ale
staple84415823st_aple
starkly14277033starkly
startle72511123startle
steeple937323steeple
stele55026843st__ele
sterile7316603sterile
stibine938663stibine
stich104117923stic__h
stichic1446243stichic
stichs114511653stic_hs
stickball1743353stickball
stickers142913033stickers
stickful1743443stickful
stickfuls1842583stickfuls
stickiest15229603stickiest
sticking153513463sticking
stickling1647003stickling
stickman1643943stickman
stickout1476333stickout
stickpin1643763stickpin
stickseed1683483stickseed
stickums1643943stickums
stickups1643303stickups
stickweed1983383stickweed
stiffie13245773stiffie
stiffly16235173stiffly
stifled113511093sti_fled
stifler102911473sti_fler
stifles103013393sti_fles
stiles64328773sti__les
still54922083sti__ll
stilled83314793sti_lled
stiller73414303sti_ller
stills64118573sti_lls
stilly93714093sti_lly
stilt54831983sti__lt
stime76521803sti__me
stimuli944513stimuli
stink95122503stink__
stinker113313313stinker
stinkier12278543stinkier
stinko10499393stink_o
stinks105616833stink_s
stinky134611073stink_y
stipe76523373sti__pe
stipel84412123stipel_
stipels9418953stipels
stippled1345303stippled
stippler1235543stippler
stipples1247023stipples
stipuled1134453stipuled
stipules1037053stipules
stirk95717413stirk__
stirks104914243stirk_s
stock114417563stock__
stockade1544523stockade
stockage1544903stockage
stocked144312873stocked
stocker133713083stocker
stockier14217253stockier
stockily1735443stockily
stockmen1643923stockmen
stockpile1743033stockpile
stocks124715633stock_s
stocky15369153stock_y
stoical9310283stoical_
stoke94922513st_ok_e
stole54928813st__ole
stopple1156583stopple
strake104017393strak_e
strick124813203strick__
stricken1436893stricken
stricks134310693strick_s
strictly1345813strictly
strike105619733strik_e
stroke105116173strok_e
stubble1136843stubble
stuck114515773stuck__
stumble1147553stumble
style85519363st__yle
suckled144212513s_uckled
suckler133413093s_uckler
suckles134516743s_uckles
suicide1038893suicide
swindle11389183swindle
swingle113510563swingle
swiple11379233swi_ple
swipple1444633swipple
swizzle1854103swizzle
tackled143913193_tackled
tackler134013323_tackler
tackles133816523_tackles
testicle1037443testic_le
thickly19415573thickly
tical76021493_tical_
ticals83214713_ticals
tick106231223_tick__
ticked134720523_ticked
ticker124321503_ticker
ticket124524853_ticket
ticklers14339303_ticklers
ticks115823293_tick_s
tike85534483_ti_k_e
tile45451443_ti__le
tingle74319063_tingle
tinkled123910473_tinkled
tinkler113610543_tinkler
tinkles113713923_tinkles
tinkly134811153_tinkly
tipple103411913_tipple
title54721073_ti_tle
tittle63613323_tittle
trickie132611033trickie
trickled152610433trickled
trickles143013763trickles
trickly16369893trickly
truckle13358863truckle
twinkle1464773twinkle
utile54718933uti__le
utricle937913utric_le
winkle133812833_winkle
wrinkle14296923wrinkle

Search took 7 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.423422437.4
2DLD Change Limit1340273136.06322105.7
3Display Results3133130.1102845.5
 (SQL Overall)1786913136.59627090.8
 
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.