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

251 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
shticks1635696(None) 
schticks19193951schticks
shtick15308021shtick_
shticky19344471shticky
shtiks13297831shti_ks
sticks125118611s_ticks
anticks134612252anticks
chicks175317592ch_icks
deticks1437352deticks
hicks145322172_h_icks
hoicks15378282_hoicks
schtick18194522schtick_
schtiks16184742schti_ks
shacks154817562sh_acks
sheiks132510012shei_ks
shicksa1634102sh_icksa
shirks134814122sh_irks
shlocks16317182shlocks
shmucks1833942shmucks
shocks154414582sh_ocks
shrieks14377672shrieks
shrinks14397912shrinks
shtik123210962shti_k_
shucks154010412sh_ucks
sicks115127622s__icks
slicks124816112s_licks
snicks124312472s_nicks
spicks144814992s_picks
stacks124317262s_tacks
stichs114511652s_tichs
stick115121562s_tick_
sticky154711342s_ticky
stinks105616832s_tinks
stirks104914242s_tirks
stocks124715632s_tocks
stricks134310692stricks
thicks154511992th_icks
ticks115823292__ticks
upticks1535152upticks
antick124814583antick_
antics84621453antic_s
attacks13126943attacks
attics84413283attic_s
batiks1239373bati_ks
bedticks1774163bedticks
bricks144614623_bricks
checks174912703ch_ecks
chicas135916473ch_icas
chick165419133ch_ick_
chicos134614833ch_icos
chics123920943ch_ic_s
chinks155817573ch_inks
chirks155414843ch_irks
chocks174815313ch_ocks
choices142010613choices
chucks174812933ch_ucks
clicks145315113_clicks
cricks144316053_cricks
detick1339383detick_
dicks125824693__dicks
entices91616333entices
ethics11169283ethic_s
flicks154512993_flicks
hacks144928713_h_acks
haiks125120933_hai_ks
hecks145220653_h_ecks
hick135530313_h_ick_
hocks144925493_h_ocks
hoick145210683_hoick_
hucks144322173_h_ucks
kicks104420093__kicks
klicks11468723_klicks
latices9313763latices
licks115325393__licks
medicks16368413medicks
micks135525373__micks
musicks15297053musicks
nicks114920493__nicks
nitpicks1643183nitpicks
notices9312283notices
nutpicks1643423nutpicks
optics102810183optic_s
outkicks1344603outkicks
photics142810483photic_s
picks135226143__picks
pricks144414263_pricks
quicks21389303_quicks
retacks132210713retacks
ricks115126133__ricks
sacks114228873s__acks
saices84221803s_aices
satins64930483sati_ns
satires72617573satires
satis55633683sati__s
schlocks19245693schlocks
schmucks2142763schmucks
schriks16185743schri_ks
schtik15185423schti_k_
septics112810433septic_s
setbacks1686303setbacks
shack145321753sh_ack_
shacko153810113sh_acko
shackos16429023sh_ackos
shairds11216263shairds
shairns10276783shairns
shanks135315583sh_anks
sharks135019723sh_arks
sheik122514663shei_k_
sheikh16206993shei_kh
sheikhs17233993sheikhs
sheilas1059403sheilas
sheuchs15234933sheuchs
shicker163914823sh_icker
shickers173012823sh_ickers
shicksas1743523sh_icksas
shiels95418923sh_iels
shiers94921753sh_iers
shies86136553sh_i_es
shifts124412943sh_ifts
shiksa1394653sh_i_ksa
shikse1386073sh_i_kse
shills94519613sh_ills
shims104422553sh_i_ms
shines95028913sh_ines
shins85131043sh_i_ns
ships105123773sh_i_ps
shires95225573sh_ires
shirk124817843sh_irk_
shirrs94413173sh_irrs
shirts94918343sh_irts
shists96515113sh_ists
shitake1455623shitake
shitakes1546113shitakes
shits84731173sh_i_ts
shivas124512413sh_ivas
shives124921413sh_ives
shivs115018803sh_i_vs
shlock15378193shlock_
shlocky19314503shlocky
shmuck1734243shmuck_
shnooks1485583shnooks
shock144917033sh_ock_
shooks134515633sh_ooks
shriek134211103shriek_
shrieky17364803shrieky
shrifts1335963shrifts
shrike134513243shri_ke
shrikes144412393shrikes
shrills10389933shrills
shrimps14516753shrimps
shrines104618693shrines
shrink134511733shrink_
shris84221453shri__s
shrives134416173shrives
shtetls1034583shtetls
shtickier1843163shtickier
shtickiest1943283shtickiest
shuck144314533sh_uck_
shylocks2044153shylocks
sices75637273s__ices
sick106435583s__ick_
sicko115315393s__icko
sickos125112033s__ickos
sics65234103s__ic_s
silicas9310603silicas
silks94620683s__ilks
sinks95529183s__inks
skinks94511653s_kinks
slacks124416533s_lacks
slices84022853s_lices
slick115520523s_lick_
slinks104315153s_links
sluices959073sluices
smacks144112323s_macks
smirks124910123s_mirks
smocks145710013s_mocks
snacks124514553s_nacks
snecks124410033s_necks
snick114416013s_nick_
socks114926083s__ocks
sonics84315633sonic_s
specks144312703s_pecks
spicas104715823s_picas
spices104326033s_pices
spick134519073s_pick_
spics94123243s_pic_s
spiks114117473s_pi_ks
splices113914383splices
stack114421693s_tack_
stalks104614553s_talks
stanks104917703s_tanks
statices102712343statices
staticky1743233staticky
statics93314533static_s
steaks104415853s_teaks
steeks103613703s_teeks
stich104117923s_tic_h
sticked144114633s_ticked
sticker133515883s_ticker
stickers142913033s_tickers
stickies142211973s_tickies
stickit1339463s_tickit
stickle132410973s_tickle
stickles142512103s_tickles
stickum1534823s_tickum
stickums1643943s_tickums
stickup1533853s_tickup
stickups1643303s_tickups
sties55132983s_ti_es
stiffs12389963s_tiffs
stiles64328773s_tiles
stills64118573s_tills
stilts67915313s_tilts
stimes85920573s_times
stings76220183s_tings
stink95122503s_tink_
stinko10499393s_tinko
stinky134611073s_tinky
stints65119763s_tints
stipes84524053s_tipes
stirk95717413s_tirk_
stirps85011823s_tirps
stirs55921623s_ti_rs
stock114417563s_tock_
stocky15369153s_tocky
stoics8311113stoic_s
stooks105115373s_tooks
storks106115953s_torks
strick124813203strick_
stuck114515773s_tuck_
sucks114523073s__ucks
swinks134610653s_winks
tacks115430133__tacks
thacks154311923th_acks
thick145613353th_ick_
thinks134613363th_inks
thwacks1953613thwacks
tick106231233__tick_
tics65729643__tic_s
tricks125319013_tricks
tucks114721123__tucks
unpicks1545183unpicks
unsticks1436233unsticks
untacks1357503untacks
untucks1334673untucks
uptick1436763uptick_
whacks184610483wh_acks
whisks16497353wh_isks
wicks144619363__wicks
wricks154610623_wricks
yoicks15375933_yoicks

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.406440125.6
2DLD Change Limit1340272516.81319672.2
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.31224438.0
 
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.