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

311 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
stickier1422976(None) 
shtickier1843161shtickier
sticker133515881stick_er
stickies142211971stickies
stickler14259571stickler
stinkier12278541stinkier
stockier14217251stockier
brickier16307162brickier
dickier143512452_dickier
ickier12439922__ickier
kickier12349052_kickier
pickier153912972_pickier
prickier16368142prickier
shicker163914822shick_er
sicker124023902s_ick_er
sickie123715742s_ickie_
sickies133717502s_ickies
sicklier1457212s_icklier
silkier114411642s_ilkier
slicker133314532slick_er
slinkier12206932slinkier
smirkier1444432smirkier
snicker133012672snick_er
spicier115112462spic_ier
spikier13369982spi_kier
stacker134416262stack_er
stalkier1257072stalkier
sticked144114632stick_ed
stickers142913032stick_ers
stickiest15229602stickiest
stickily1736082stickily
sticking153513462sticking
stickit1339462sticki_t
stickle132410972stickle_
stickled15298972stickled
sticklers15227392sticklers
stickles142512102stickles
stickmen1634542stickmen
stillier868832stillier
stingier9279122stingier
stinker113313312stink_er
stocker133713082stock_er
suckier133613972s_uckier
tackier133712522_tackier
ticker124321502_tick_er
tickler133612652_tickler
trickier143010232trickier
bicker144819173_bick_er
bitchier15307733bitchier
blockier1666133blockier
chichier1836023chichier
chinkier17377363chinkier
clicker154111883click_er
cockier154013623_cockier
colickier1743513colickier
deticker1545283detick_er
dicier94416233_dic_ier
dicker134521403_dick_er
dickie133913113_dickie_
dickies143416343_dickies
dictier103411863_dictier
dinkier123411503_dinkier
duckier143911793_duckier
fickler16348423_fickler
finickier1842623finickier
flicker163610623flick_er
flockier1745343flockier
friskier1535193friskier
hickie153812473_hickie_
hickies163614743_hickies
hinkier143610793_hinkier
icier74313753__ic_ier
icker114018443__ick_er
inkier104013783__inkier
itchier12247673it_chier
juicier1635463juic_ier
kicker114116183_kick_er
kinkier10319433_kinkier
licker125222043_lick_er
luckier133811533_luckier
mickler153310233_mickler
milkier133411163_milkier
mirkier13319053_mirkier
muckier153411483_muckier
nicker123818703_nick_er
nitpickier1851213nitpickier
panickier1743173panickier
peckier153910523_peckier
pickeer153710113_pickeer
picker144422173_pick_er
pitchier15368273pitchier
pluckier16295073pluckier
pockier153911603_pockier
pricier113313113pric_ier
pricker154013413prick_er
pricklier17245063pricklier
quackier23215373quackier
quicker2247023quick_er
quickie2235513quickie_
quickies2336773quickies
quirkier2134163quirkier
riskier1138423_riskier
rockier134911883_rockier
sacker125124843s_ack_er
sarkier113413313s_arkier
satisfier1243733satisfier
saucier9810283sauc_ier
shackler17317973shackler
shakier143411153s_hakier
shickers173012823shick_ers
shiftier1436343shiftier
shikker13277023shi_kker
shinier104113143shi_nier
shirker143711343shirk_er
shirtier1137943shirtier
shittier1137313shittier
shlockier1842583shlockier
shocker163411433shock_er
shriekier1652963shriekier
shtickiest1943283shtickiest
shucker163710103shuck_er
sickbed16396823s_ickbed
sicked134524403s_ick_ed
sickee124622223s_ick_ee
sickees134514213s_ickees
sicken124615253s_ick_en
sickener1436603s_ickener
sicking143720173s_icking
sickish1638423s_ickish
sickle124418323s_ickle_
sickled144713433s_ickled
sickles133417543s_ickles
sicklied1546583s_icklied
sicklies14710013s_icklies
siker95326033s_i_k_er
silkie103313403s_ilkie_
silkies113715693s_ilkies
sillier74017593s_illier
siltier73413863s_iltier
sinker103620903s_ink_er
sissier73711363s_issier
sizier1514813393s_i_zier
skankier11184883skankier
skiddier1464193skiddier
skier95119603s___kier
skimpier1634293skimpier
skinker10319443skink_er
skinnier1264893skinnier
skunkier11174283skunkier
slacker133915293slack_er
sleekier1245573sleekier
slicer84117603slic__er
slicked144413843slick_ed
slicken13309293slick_en
slickener1544043slickener
slickers143112553slick_ers
slicking153712593slicking
slickster1543413slickster
slimier93212013sli_mier
slimsier1085213slimsier
slippier1256543slippier
slittier837003slittier
smacker153410583smack_er
smirker13327423smirk_er
smokier1356703s_mokier
snacker133112603snack_er
snakier112810003s_nakier
snarkier12336513snarkier
sneakier1245143sneakier
snicked143811633snick_ed
snickerer15134563snickerer
snickers143010963snick_ers
snickery17295543snick_ery
snicking153610233snicking
sniffier14356643sniffier
snippier1255793snippier
spacier114011633spac_ier
sparkier14298033sparkier
spicer104719313spic__er
spiffier16255883spiffier
spiker124315663spi_k_er
spinier93715163spi_nier
spirier93214073spi_rier
spookier14175493spookier
spunkier14235823spunkier
stacked143416123stack_ed
stackers143413563stack_ers
stacking154215083stacking
staggier10167513staggier
stagier83513443st_agier
stalker113912253stalk_er
starchier1436643starchier
starker114114693stark_er
starrier8279463starrier
steadier937313steadier
steamier1048303steamier
steelier839203steelier
stemmier1245253stemmier
stenchier1445333stenchier
stichic1446243stichi_c
stick115121563stick___
stickful1743443stickful
stickiness1635903stickiness
sticklike1444003sticklike
stickling1647003stickling
stickman1643943stickman
stickout1476333stickout
stickpin1643763stickpin
stickpins1744093stickpins
sticks125118613stick__s
stickseed1683483stickseed
stickum1534823stick_um
stickums1643943stickums
stickup1533853stick_up
stickups1643303stickups
stickweed1983383stickweed
stickwork17133443stickwork
sticky154711343stick__y
stiction1038823stiction
stiffer13319393sti_ffer
stiffie13245773stiffie_
stiffies14258383stiffies
stifler102911473sti_fler
stiller73414303sti_ller
stimied10310623sti_mied
stimies9316563sti_mies
stinger84314683sti_nger
stinkers123111133stink_ers
stinkiest13198463stinkiest
stinking133113543stinking
stinter73614513sti_nter
stippler1235543stippler
stirrer7338233sti_rrer
stitcher13168393stitcher
stithied1235303stithied
stithies1139233stithies
stiver93915733sti__ver
stockcar1642923stockcar
stocked144312873stock_ed
stockers143411073stock_ers
stockiest15207753stockiest
stockily1735443stockily
stockinet1547193stockinet
stocking152912503stocking
stockish17186043stockish
stockist14197713stockist
stockmen1643923stockmen
stockpiler1842343stockpiler
stodgier1034223stodgier
stoker104417623st_ok_er
stonier72013793st_onier
stooker113811733stook_er
stormier1036103stormier
strawier1137493strawier
streakier1334843streakier
stricken1436893strick_en
strickle1467793strickle_
strickled1665833strickled
strickles1567813strickles
stricter1039423stric_ter
striker113714173strik_er
stringier1036713stringier
stripier1058863stripier
stroker114113523strok_er
stubbier1235353stubbier
stuccoer1252803stuccoer
studier82510053st_udier
studlier935473studlier
stuffier14336623stuffier
stumpier1255883stumpier
sturdier9216963sturdier
sucker124120663s_uck_er
suckler133413103s_uckler
sulkier113811963s_ulkier
swankier15225503swankier
swimmier15174313swimmier
swingier12267003swingier
swirlier1135213swirlier
swishier1434563swishier
tacker124224503_tack_er
tackler134013323_tackler
talkier114011843_talkier
techier1269243_techier
thicker163611023thick_er
ticked134720523_tick_ed
tickers133617723_tick_ers
ticket124524853_tick_et
ticking143218753_ticking
tickle124616743_tickle_
tickled144313133_tickled
ticklers14339303_ticklers
tickles133416853_tickles
tidier73515113_ti_dier
tinier63622233_ti_nier
tinker103619923_tink_er
tinkler113610543_tinkler
tinklier1255443_tinklier
tinnier72910143_tinnier
tippier113210543_tippier
tipsier9268893_tipsier
tricker134615523trick_er
trickie132611033trickie_
tricklier15256823tricklier
tricksier15275243tricksier
tucker124316953_tuck_er
wackier16369733_wackier
whackier2044673whackier
whicker19359773whick_er
wicker154518673_wick_er
witchier16307883witchier
yuckier16358533_yuckier

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.423422437.4
2DLD Change Limit1461623117.39019778.3
3Display Results3113110.1232528.5
 (SQL Overall)1786913117.93622516.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.