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 “sticks” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
sticks12511861(None) 
shticks16356961shticks
sicks115127621s_icks
slicks124816111slicks
snicks124312471snicks
spicks144814991spicks
stacks124317261stacks
stichs114511651stichs
stick115121561stick_
sticky154711341sticky
stinks105616831stinks
stirks104914241stirks
stocks124715631stocks
stricks134310691stricks
ticks115823291_ticks
anticks134612252anticks
bricks144614622bricks
chicks175317592chicks
clicks145315112clicks
cricks144316052cricks
deticks1437352deticks
dicks125824692_dicks
flicks154512992flicks
hicks145322172_hicks
hoicks15378282hoicks
kicks104420082_kicks
klicks11468722klicks
licks115325392_licks
micks135525372_micks
nicks114920492_nicks
picks135226142_picks
pricks144414262pricks
quicks21389302quicks
ricks115126132_ricks
sacks114228872s_acks
saices84221802saices
schticks19193952schticks
shacks154817562shacks
shicksa1634102shicksa
shirks134814122shirks
shocks154414582shocks
shtick15308022shtick_
shticky19344472shticky
shtiks13297832shti_ks
shucks154010412shucks
sices75637272s_ices
sick106435572s_ick_
sicko115315392s_icko
sickos125112032s_ickos
sics65234092s_ic_s
silks94620682s_ilks
sinks95529182s_inks
skinks94511652skinks
slacks124416532slacks
slices84022852slices
slick115520522slick_
slinks104315152slinks
smacks144112322smacks
smirks124910122smirks
smocks145710012smocks
snacks124514552snacks
snecks124410032snecks
snick114416012snick_
socks114926082s_ocks
specks144312702specks
spicas104715822spicas
spices104326032spices
spick134519072spick_
spics94123242spic_s
spiks114117472spi_ks
stack114421692stack_
stalks104614552stalks
stanks104917702stanks
steaks104415852steaks
steeks103613702steeks
stich104117922stic_h
sticked144114632sticked
sticker133515882sticker
stickers142913032stickers
stickies142211972stickies
stickit1339462stickit
stickle132410972stickle
stickles142512102stickles
stickum1534822stickum
stickums1643942stickums
stickup1533852stickup
stickups1643302stickups
sties55132982sti_es
stiffs12389962stiffs
stiles64328772stiles
stills64118572stills
stilts67915312stilts
stimes85920572stimes
stings76220182stings
stink95122502stink_
stinko10499392stinko
stinky134611072stinky
stints65119762stints
stipes84524052stipes
stirk95717412stirk_
stirps85011822stirps
stirs55921622sti_rs
stock114417562stock_
stocky15369152stocky
stoics8311112stoic_s
stooks105115372stooks
storks106115952storks
strick124813202strick_
stuck114515772stuck_
sucks114523072s_ucks
swinks134610652swinks
tacks115430132_tacks
thicks154511992thicks
tick106231222_tick_
tics65729632_tic_s
tricks125319012tricks
tucks114721122_tucks
unsticks1436232unsticks
upticks1535152upticks
wicks144619362_wicks
wricks154610622wricks
yoicks15375932yoicks

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825511222.29635954.3
3Display Results1221220.0333697.0
 (SQL Overall)1786911222.68966452.6
 
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.