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

150 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
stickit133946(None) 
sickie123715742s_ickie
stichic1446242stichic
stick115121562stick__
sticked144114632sticked
sticker133515882sticker
stickier14229762stickier
stickies142211972stickies
stickiest15229602stickiest
stickily1736082stickily
sticking153513462sticking
stickle132410972stickle
stickout1476332stickout
stickpin1643762stickpin
sticks125118612stick_s
stickum1534822stickum
stickup1533852stickup
sticky154711342stick_y
stockist14197712stockist
ticket124524852_ticket
cricket154716953cricket
dickie133913113_dickie
elicit8417203elic_it
hickie153812473_hickie
licit74327683_lic_it
picket144924313_picket
pricket153616443pricket
quickie2235513quickie
shicker163914823shicker
shicksa1634103shicksa
shilpit1247093shilpit
shtick15308013shtick__
shtickier1843163shtickier
shtickiest1943283shtickiest
shticks16356963shtick_s
shticky19344473shtick_y
sick106435573s_ick__
sicked134524403s_icked
sickee124622223s_ickee
sicken124615253s_icken
sicker124023903s_icker
sickest131813793s_ickest
sickies133717503s_ickies
sicking143720173s_icking
sickish1638423s_ickish
sickle124418323s_ickle
sickly153110483s_ickly
sicko115315393s_ick_o
sickos125112033s_ickos
sickout1359373s_ickout
sicks115127623s_ick_s
silkie103313403s_ilkie
siskin1079783s_iskin
skit85437523s___kit
sleekit1145453sleekit
slick115520523slick__
slicked144413843slicked
slicken13309293slicken
slicker133314533slicker
slickest14229253slickest
slicking153712593slicking
slickly1635853slickly
slicks124816113slick_s
snick114416013snick__
snicked143811633snicked
snicker133012673snicker
snicking153610233snicking
snicks124312473snick_s
socket123923523s_ocket
solicit9315743solic_it
spick134519073spick__
spicks144814993spick_s
spirit83519923spi_rit
stack114421693stack__
stacked143416123stacked
stacker134416263stacker
stacking154215083stacking
stacks124317263stack_s
stackup1533743stackup
starlit71512913starlit
stibnite1044073stibnite
stich104117923stic__h
stichs114511653stic_hs
stickers142913023stickers
stickful1743443stickful
stickled15298973stickled
stickler14259573stickler
stickles142512103stickles
sticklike1444003sticklike
stickling1647003stickling
stickman1643943stickman
stickmen1634543stickmen
stickouts1553963stickouts
stickpins1744083stickpins
sticktight2051823sticktight
stickums1643943stickums
stickups1643303stickups
stiction1038813stiction
stiffie13245773stiffie
stilbite1045413stilbite
stilt54831983sti__lt
stink95122503stink__
stinker113313313stinker
stinkier12278543stinkier
stinkiest13198463stinkiest
stinking133113543stinking
stinko10499393stink_o
stinkpot1443633stinkpot
stinks105616833stink_s
stinky134611073stink_y
stint57037663sti__nt
stirk95717413stirk__
stirks104914233stirk_s
stock114417563stock__
stocked144312873stocked
stocker133713083stocker
stockier14217253stockier
stockiest15207753stockiest
stockily1735443stockily
stockinet1547193stockinet
stocking152912503stocking
stockish17186043stockish
stockists15194563stockists
stockpot1644663stockpot
stocks124715633stock_s
stocky15369153stock_y
strait64025893st_rait
strick124813203strick__
stricken1436893stricken
strickle1467793strickle
stricks134310693strick_s
strict84821043stric__t
stuck114515773stuck__
tacit76333673_tac_it
tacket124627493_tacket
thicket163213073thicket
tick106231223_tick__
ticked134720523_ticked
ticker124321503_ticker
tickets134113683_tickets
ticking143218753_ticking
tickle124616743_tickle
ticks115823293_tick_s
tidbit938483_tidbit
tiki87620843_ti_ki_
tikis95615973_ti_kis
titbit839813_titbit
trickie132611033trickie
tucket124219483_tucket
wicket155318943_wicket

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271507.18618651.1
3Display Results1501500.0503000.0
 (SQL Overall)1786911507.39224173.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.