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

282 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
stickies14221197(None) 
sickies133717501s_ickies
stickier14229761stickier
stickiest15229601stickiest
stickles142512101stickles
dickies143416342_dickies
hickies163614742_hickies
quickies2336772quickies
shtickier1843162shtickier
shtickiest1943282shtickiest
sickees134514212s_ickees
sickie123715742s_ickie_
sickles133417542s_ickles
sicklies14710012s_icklies
silkies113715692s_ilkies
sticked144114632stick_ed
sticker133515882stick_er
stickers142913032stickers
stickily1736082stickily
stickiness1635902stickiness
sticking153513462sticking
stickit1339462sticki_t
stickle132410972stickle_
stickled15298972stickled
stickler14259572stickler
sticklers15227392sticklers
stickmen1634542stickmen
stickpins1744092stickpins
sticks125118612stick__s
stickums1643942stickums
stickups1643302stickups
stiffies14258382stiffies
stimies9316562sti_mies
stinkier12278542stinkier
stinkiest13198462stinkiest
stithies1139232stithies
stockier14217252stockier
stockiest15207752stockiest
strickles1567812strickles
tickles133416852_tickles
bikies124515163_bi_kies
birkies133712433_birkies
brickier16307163brickier
brickiest1737433brickiest
brickles162810283brickles
chickees19258513chickees
chuckies1937703chuckies
dickie133913113_dickie_
dickier143512453_dickier
dickiest153412503_dickiest
dinkies123716033_dinkies
duckies143613813_duckies
hackies163418243_hackies
hickie153812473_hickie_
ickier12439923__ickier
ickiest133611043__ickiest
jackies202912623_jackies
kickier12349053_kickier
kickiest13319673_kickiest
luckies133313683_luckies
mickles153415003_mickles
nickles133713823_nickles
nitchies1339073nitchies
ostiaries948803ostiaries
pickier153912973_pickier
pickiest162712593_pickiest
pickles153215443_pickles
pinkies133818263_pinkies
pliskies1475973pliskies
prickier16368143prickier
prickiest1748183prickiest
prickles162511093prickles
quickie2235513quickie_
saices84221803saic__es
satieties939383satieties
satisfies1245323satisfies
scries85226823s__cries
seiches12513813seic_hes
selkies113513353s_elkies
shackles173010593shackles
shackoes17367853shackoes
shicker163914823shick_er
shickers173012823shickers
shicksas1743523shicksas
shikses14116573shi_kses
shimmies15287803shimmies
shindies122610503shindies
shinnies113010913shinnies
shticks16356963shtick__s
sices75637273s_ic__es
sickbed16396823s_ickbed
sickbeds17254213s_ickbeds
sicked134524403s_ick_ed
sickee124622223s_ick_ee
sicken124615253s_ick_en
sickens134411483s_ickens
sicker124023903s_ick_er
sickest131813793s_ick_est
sicking143720173s_icking
sickish1638423s_ickish
sickle124418323s_ickle_
sickled144713433s_ickled
sicklied1546583s_icklied
sicklier1457213s_icklier
sickliest1547523s_ickliest
sickness1437833s_ickness
sickos125112033s_ick_os
sicks115127623s_ick__s
sikes96236083s_i_k_es
silkie103313403s_ilkie_
silkier114411643s_ilkier
silkiest123212853s_ilkiest
sillies73425083s_illies
siskins1159583s_iskins
sissies73716603s_issies
sixties14310973s_ixties
skies95026833s___kies
skivvies18112883skivvies
slices84022853slic__es
slicked144413843slick_ed
slicken13309293slick_en
slickens14317263slickens
slicker133314533slick_er
slickers143112553slickers
slickest14229253slick_est
slicking153712593slicking
slickness1535903slickness
slicks124816113slick__s
slinkier12206933slinkier
slinkiest13188083slinkiest
smirkier1444433smirkier
smirkiest1535193smirkiest
smithies1337913smithies
snicked143811633snick_ed
snicker133012673snick_er
snickers143010963snickers
snicking153610233snicking
snicks124312473snick__s
spackles16319953spackles
species11314133spec_ies
speckles16268133speckles
spiceries1349313spiceries
spices104326033spic__es
spicier115112463spic_ier
spiciest122711613spic_iest
spicks144814993spick__s
spicules12219803spicules
spiffies16277993spiffies
spikes124520713spi_k_es
spikier13369983spi_kier
spikiest14259543spi_kiest
spinnies103210543spinnies
spunkies14227593spunkies
stacked143416123stack_ed
stacker134416263stack_er
stackers143413563stackers
stacking154215083stacking
stackless1555933stackless
stacks124317263stack__s
stackups1643313stackups
stactes91914633stac_tes
staggies101210323staggies
stakes103927293st_ak_es
stalkier1257073stalkier
stalkiest1347913stalkiest
steadies9311123steadies
steelies8312553steelies
stenokies1345313stenokies
stibines1038153stibines
stibnites1144043stibnites
stichic1446243stichi_c
stichs114511653stic__hs
stick115121563stick___
stickful1743443stickful
stickfuls1842583stickfuls
sticklike1444003sticklike
stickling1647003stickling
stickman1643943stickman
stickout1476333stickout
stickouts1553973stickouts
stickpin1643763stickpin
stickseed1683483stickseed
stickseeds1772383stickseeds
stickum1534823stick_um
stickup1533853stick_up
stickweed1983383stickweed
stickweeds2082443stickweeds
sticky154711343stick__y
stiction1038823stiction
stictions1148353stictions
sties55132983st___ies
stiffie13245773stiffie_
stifles103013393sti_fles
stilbites1144833stilbites
stiles64328773sti__les
stillier868823stillier
stilliest939223stilliest
stimes85920573sti__mes
stimied10310623sti_mied
stingier9279123stingier
stingiest10209773stingiest
stinker113313313stink_er
stinkers123111133stinkers
stinking133113543stinking
stinks105616833stink__s
stipes84524053sti__pes
stipites1039653stipites
stipples1247023stipples
stipules1037053stipules
stirks104914243stirk__s
stirpes95011293sti_rpes
stitches131410593stitches
stithied1235303stithied
stockades1644433stockades
stockages1644923stockages
stocked144312873stock_ed
stocker133713083stock_er
stockers143411073stockers
stockily1735443stockily
stockiness1645243stockiness
stockinet1547193stockinet
stockinets1643533stockinets
stocking152912503stocking
stockings16296093stockings
stockish17186043stockish
stockist14197713stockist
stockists15194563stockists
stockmen1643923stockmen
stockpiles1842993stockpiles
stocks124715633stock__s
stogies8413693st_ogies
stokes104821793st_ok_es
stoolies8311083stoolies
stories7324273st_ories
strakes114218073strak_es
stricken1436893strick_en
strickle1467793strickle_
strickled1665833strickled
stricks134310693strick__s
strikes114719093strik_es
strokes114316323strok_es
stuccoes1254273stuccoes
studdies10207073studdies
studies82413863st_udies
sturdies92110273sturdies
stymies1239213st_ymies
suckier133613973s_uckier
suckiest143314113s_uckiest
suckles134516743s_uckles
suicides1139083suicides
sulkies114315763s_ulkies
tackier133712523_tackier
tackiest143112433_tackiest
tackles133816523_tackles
talkies113415733_talkies
techies12513603_techies
tekkies1035943_tekkies
ticked134720523_tick_ed
ticker124321503_tick_er
tickers133617723_tickers
ticket124524853_tick_et
tickets134113683_tickets
ticking143218753_ticking
tickings15368583_tickings
tickle124616743_tickle_
tickled144313133_tickled
tickler133612653_tickler
ticklers14339303_ticklers
ticks115823293_tick__s
tidies74721833_ti_dies
tikes95628903_ti_k_es
tikis95615973_ti_ki_s
tinkles113713923_tinkles
titties73617363_titties
tizzies15287893_tizzies
trickie132611033trickie_
trickier143010233trickier
trickiest1549023trickiest
trickles143013763trickles
twinkies1535983twinkies
vichies15310623_vichies
whiskies1835953whiskies

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.436409841.7
2DLD Change Limit1461622827.29620033.2
3Display Results2822820.1102563.6
 (SQL Overall)1786912827.84222786.4
 
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.