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

199 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
sticklers1522739(None) 
stickers142913031stick_ers
stickler14259571stickler_
stickles142512101stickle_s
ticklers14339301_ticklers
shacklers18336032shacklers
shickers173012822shick_ers
sickles133417542s_ickle_s
slickers143112552slick_ers
snickers143010962snick_ers
stackers143413562stack_ers
stackless1555932stackless
sticker133515882stick_er_
stickier14229762stickier_
stickies142211972stickie_s
stickle132410972stickle__
stickled15298972stickle_d
stiflers11238832sti_flers
stinkers123111132stink_ers
stipplers1334452stipplers
stockers143411072stock_ers
strickles1567812strickle_s
sucklers14379962s_ucklers
tacklers143010772_tacklers
tickers133617722_tick_ers
tickler133612652_tickler_
tickles133416852_tickle_s
tinklers12298182_tinklers
bickers154316553_bick_ers
brickles162810283brickle_s
bucklers16349503_bucklers
cacklers163710703_cacklers
chucklers2034443chucklers
clickers163910203click_ers
clickless1743983clickless
detickers1634423detick_ers
dickers144117663_dick_ers
fickler16348423_fickler_
flickers17338883flick_ers
hacklers173710303_hacklers
hecklers17357123_hecklers
ickers123914183__ick_ers
kickers124013293_kick_ers
knickers13306723knick_ers
knucklers1483043knucklers
lickers134118253_lick_ers
mickler153310233_mickler_
mickles153415003_mickle_s
nickers134415093_nick_ers
nickles133713823_nickle_s
pickeers16347243_pickeers
pickers153718093_pick_ers
pickles153215443_pickle_s
prickers163710673prick_ers
prickles162511093prickle_s
sackers133820223s_ack_ers
sailers73822323sai__lers
scalers93817263s__calers
shackler17317973shackler_
shackles173010593shackle_s
shicker163914823shick_er_
shikkers14326523shi_kkers
shinglers13246443shinglers
shirkers15319583shirk_ers
shockers17319463shock_ers
shtickier1843163shtickier_
shuckers17388133shuck_ers
sickbeds17254213s_ickbeds
sickees134514213s_ick_ees
sickeners1535733s_ickeners
sickens134411483s_ick_ens
sicker124023903s_ick_er_
sickies133717503s_ickie_s
sickle124418323s_ickle__
sickled144713433s_ickle_d
sicklier1457213s_icklier_
sicklies14710013s_icklies
sickness1437833s_ickness
sidlers83414233s_i_dlers
sillers73822103s_i_llers
sinkers113618543s_ink_ers
sizzlers16274753s_izzlers
skinkers11298183skink_ers
slackers143812743slack_ers
slicers94114923slic__ers
slickeners1643663slickeners
slickens14317263slick_ens
slicker133314533slick_er_
slickness1535903slickness
slicksters1643393slicksters
smackers16318713smack_ers
smilers94113853smi__lers
smirkers14316353smirk_ers
snackers143010223snack_ers
snicker133012673snick_er_
snickerers16133583snickerers
snickery17295543snick_ery
snifflers15275053snifflers
snigglers11314593snigglers
snivelers1264533snivelers
sockless14267793s_ockless
spackles16319953spackle_s
sparklers15315643sparklers
speckles16268133speckle_s
spiceless1335923spiceless
spicers113815553spic__ers
spicules12219803spicule_s
spielers10319653spi_elers
spikers135311993spi_k_ers
spillers103311703spi_llers
spindlers12286453spindlers
sprinklers1642973sprinklers
stablers103611153st_ablers
stacker134416263stack_er_
stalkers12369853stalk_ers
stalkless1333723stalkless
staplers103111203st_aplers
starkers123712393stark_ers
startlers9236743startlers
stealers83412213st_ealers
stencilers1243003stencilers
sticked144114633stick_e_d
stickfuls1842583stickfuls
stickiest15229603stickiest
stickiness1635903stickiness
sticklike1444003sticklike
stickling1647003stickling
stickmen1634543stickme_n
stickouts1553973stickouts
stickpins1744093stickpins
sticks125118613stick___s
stickseed1683483stickseed
stickseeds1772393stickseeds
stickums1643943stick_ums
stickups1643303stick_ups
stickweed1983383stickweed
stickweeds2082443stickweeds
stickwork17133443stickwork
stickworks18113333stickworks
stifler102911473sti_fler_
stifles103013393sti_fle_s
stiles64328773sti__le_s
stiller73414303sti_ller_
stingers94012743sti_ngers
stingless1046463stingless
stinker113313313stink_er_
stinkier12278543stinkier_
stinters83312763sti_nters
stippler1235543stippler_
stipples1247023stipple_s
stipules1037053stipule_s
stirrers8266943sti_rrers
stitchers14147013stitchers
stivers103613543sti__vers
stockcars1742973stockcars
stocker133713083stock_er_
stockier14217253stockier_
stockpilers1961913stockpilers
stokers114515183st_ok_ers
stookers12449793stook_ers
strickle1467793strickle__
strickled1665833strickle_d
strikers123611293strik_ers
strokers123910913strok_ers
strollers937563strollers
stuccoers1342563stuccoers
stumblers1334383stumblers
stylers10359353st__ylers
suckers133717623s_uck_ers
suckler133413093s_uckler_
suckles134516743s_uckle_s
suckless14288823s_uckless
swillers11299113swi_llers
swindlers13306033swindlers
swizzlers2052193swizzlers
tackers134319623_tack_ers
tackler134013323_tackler_
tackles133816523_tackle_s
tackless14419483_tackless
ticker124321503_tick_er_
tickets134113683_tick_ets
tickle124616743_tickle__
tickled144313133_tickle_d
tiddlers10288653_tiddlers
tilers63523503_ti__lers
tillers73418743_ti_llers
tinglers93710593_tinglers
tinkers113517143_tink_ers
tinkler113610543_tinkler_
tinkles113713923_tinkle_s
tipplers12336353_tipplers
trickers143812813trick_ers
trickles143013763trickle_s
trucklers15295583trucklers
tuckers134014353_tuck_ers
twinklers1633063twinklers
whickers20297983whick_ers
wickers164114703_wick_ers
wickless1736083_wickless

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411997.37320160.2
3Display Results1991990.0802487.5
 (SQL Overall)1786911997.90622601.9
 
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.