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

139 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
shticky1934447(None) 
shtick15308021shtick_
shticks16356961shticks
sticky154711341s_ticky
schtick18194522schtick_
schticks19193952schticks
shlocky19314502shlocky
shrieky17364802shrieky
shtik123210962shti_k_
shtiks13297832shti_ks
staticky1743232staticky
stick115121562s_tick_
sticks125118612s_ticks
stinky134611072s_tinky
stocky15369152s_tocky
antick124814583antick_
anticks134612253anticks
anticly12410053anticly
bricky17489093_bricky
chick165419133ch_ick_
chicks175317593ch_icks
chicly16429203ch_icly
chinky185610543ch_inky
chucky20418003ch_ucky
colicky1835783colicky
detick1339383detick_
deticks1437353deticks
dicky154816243__dicky
finicky1943713finicky
hick135530303_h_ick_
hickey185011993_h_ickey
hicks145322173_h_icks
hinky155618753_h_inky
hoick145210683_hoick_
hoicks15378283_hoicks
icky136315753___icky
kicky135012333__kicky
nitpicky1951693nitpicky
panicky1833853panicky
picky165416943__picky
pricky174210343_pricky
satiety1038203satiety
satiny93817983sati_ny
satisfy1344183satisfy
schlocky22243383schlocky
schtik15185423schti_k_
schtiks16184743schti_ks
shack145321753sh_ack_
shacko153810113sh_acko
shacks154817563sh_acks
shaky154616843sh__aky
sheik122514663shei_k_
sheikh16206993shei_kh
sheiks132510013shei_ks
shicker163914823sh_icker
shicksa1634103sh_icksa
shifty15409263sh_ifty
shily115222013sh_i_ly
shimmy16306413sh_immy
shindy13449323sh_indy
shinny124810783sh_inny
shiny115122143sh_i_ny
shirk124817843sh_irk_
shirks134814123sh_irks
shirty124312563sh_irty
shitake1455623shitake
shitty124110063sh_itty
shlock15378193shlock_
shlocks16317183shlocks
shmuck1734243shmuck_
shmucks1833943shmucks
shock144917033sh_ock_
shocks154414583sh_ocks
shriek134211103shriek_
shrieks14377673shrieks
shrike134513243shri_ke
shrilly13318563shrilly
shrimpy17415403shrimpy
shrink134511733shrink_
shrinks14397913shrinks
shtickier1843163shtickier
shuck144314533sh_uck_
shucks154010413sh_ucks
sick106435573s__ick_
sickly153110483s__ickly
sicko115315393s__icko
sicks115127623s__icks
silky125315823s__ilky
slick115520523s_lick_
slickly1635853s_lickly
slicks124816113s_licks
slinky13399103s_linky
sluicy1166483sluic_y
smirky15406943s_mirky
snick114416013s_nick_
snicks124312473s_nicks
spicey134414233s_picey
spick134519073s_pick_
spicks144814993s_picks
spicy125417713s_pic_y
spiky146014113s_pi_ky
stack114421693s_tack_
stacks124317263s_tacks
stalky13499303s_talky
stich104117923s_tic_h
stichs114511653s_tichs
sticked144114633s_ticked
sticker133515883s_ticker
stickily1736083s_tickily
stickit1339463s_tickit
stickle132410973s_tickle
stickum1534823s_tickum
stickup1533853s_tickup
stilly93714093s_tilly
stimy105114743s_ti_my
stingy105213203s_tingy
stink95122503s_tink_
stinko10499393s_tinko
stinks105616833s_tinks
stirk95717413s_tirk_
stirks104914243s_tirks
stithy12398213s_tithy
stock114417563s_tock_
stocks124715633s_tocks
strick124813203strick_
stricks134310693stricks
stuck114515773s_tuck_
sucky144415503s__ucky
tacky145617443__tacky
thick145613353th_ick_
thickly19415573th_ickly
thicks154511993th_icks
tick106231223__tick_
ticks115823293__ticks
tricky154211473_tricky
uptick1436763uptick_
upticks1535153upticks
whacky21556493wh_acky
whisky19455903wh_isky

Search took 7 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.423422437.4
2DLD Change Limit1340271396.17321711.8
3Display Results1391390.0463021.7
 (SQL Overall)1786911396.64226903.2
 
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.