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

407 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
stricks13431069(None) 
sticks125118611st_icks
strick124813201strick_
tricks125319011_tricks
astricts1049462astricts
bricks144614622_bricks
cricks144316052_cricks
pricks144414262_pricks
ricks115126132__ricks
shrieks14377672shrieks
shrinks14397912shrinks
shticks16356962shticks
sicks115127622s__icks
slicks124816112s_licks
snicks124312472s_nicks
spicks144814992s_picks
stacks124317262st_acks
stichs114511652st_ichs
stick115121562st_ick_
sticky154711342st_icky
stinks105616832st_inks
stirks104914242st_irks
stocks124715632st_ocks
stoics8311112stoic_s
streaks114411272streaks
streeks11378712streeks
stricken1436892stricken
strickle1467792strickle
strickles1567812strickles
strict84821042stric_t
strides84520392strides
strifes104716582strifes
strike105619732stri_ke
strikes114719092strikes
strings84617132strings
stripes95320572stripes
strips85719652stri_ps
strives104119372strives
struck12489262struck_
thicks154511992_thicks
ticks115823292_t_icks
tracks124818842_tracks
trices84826332_trices
trick115420692_trick_
tricksy16436582_tricksy
tricky154211472_tricky
trocks123614632_trocks
trucks124711972_trucks
wricks154610622_wricks
abstricts1355183abstricts
amtracks1696633amtracks
anticks134612253anticks
arracks1387733arracks
asterisks1346813asterisks
astrict9614793astric_t
atriums939043atriums
attacks13126943attacks
attics84413283attic_s
brick134618153_brick_
bricky17489093_bricky
brinks124616313_brinks
brisks124611403_brisks
brocks145214153_brocks
caracks152211563caracks
carices114220953carices
chicks175317593_chicks
clicks145315113_clicks
cracks144817003_cracks
crick135118753_crick_
crocks145118423_crocks
crucks144412583_crucks
darics94314113daric_s
derricks1544433derricks
deticks1437353deticks
dicks125824693__dicks
districts1248933districts
dornicks1544403dornicks
drecks13459203_drecks
drinks116810713_drinks
ericas8315463_ericas
estrins7315853estri_ns
estriols856253estriols
ethics11169283ethic_s
flicks154512993_flicks
frisks13479263_frisks
frocks154111213_frocks
hatracks1737533hatracks
hayricks2043763hayricks
hicks145322173__hicks
hoicks15378283_hoicks
kicks104420083__kicks
klicks11468723_klicks
licks115325393__licks
lyrics11357943lyric_s
matrices12312083matrices
medicks16368413medicks
metrics11312363metric_s
micks135525373__micks
murices112612283murices
musicks15297053musicks
myricas1436753myricas
nicks114920493__nicks
nitpicks1643183nitpicks
nutpicks1643423nutpicks
orrices9129363orrices
ostrich1238663ostric_h
ostriches1446633ostriches
outkicks1344603outkicks
outrocks1437903outrocks
outtricks1544323outtricks
picks135226143__picks
prices104524543_prices
prick134317503_prick_
pricky174210343_pricky
prinks124315383_prinks
quicks21389303_quicks
racks115028853__racks
recks115625133__recks
reracks132310533reracks
restricts1138823restricts
retracks14149103retracks
rices75536153__rices
rick107334653__rick_
rinks94827103__rinks
risks94917063__risks
rocks114626413__rocks
rucks114422053__rucks
sacks114228873s__acks
saices84221803s_aices
sarins63932623sari_ns
saris54544953sari__s
sarks96632463sar__ks
schriks16185743schri_ks
schticks19193953schticks
scraichs1543993scraichs
screaks13469363screaks
scribes113713203scribes
scries85226823scri_es
scrimps13517903scrimps
scrims104615933scri_ms
scrips105316033scri_ps
scripts11509373scripts
scrives124414273scrives
seracs84418573serac_s
serials73919743serials
sericin9312843sericin
sericins10312463sericins
series64540973seri_es
serifs94017053seri_fs
serines74229543serines
serins64029673seri_ns
serious73616283serious
services1338573services
setbacks1686303setbacks
sferics1236133sferic_s
shacks154817563s_hacks
sheiks132510013shei_ks
shicksa1634103s_hicksa
shirks134814123s_hirks
shlocks16317183shlocks
shmucks1833943shmucks
shocks154414583s_hocks
shriek134211103shriek_
shrieky17364803shrieky
shrifts1335963shrifts
shrike134513243shri_ke
shrikes144412393shrikes
shrills10389933shrills
shrimps14516753shrimps
shrines104618693shrines
shrink134511733shrink_
shris84221453shri__s
shrives134416173shrives
shtick15308023shtick_
shticky19344473shticky
shtiks13297833shti_ks
shucks154010413s_hucks
sices75637273s__ices
sick106435573s__ick_
sicko115315393s__icko
sickos125112033s__ickos
sics65234093s__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
sorings83817253sorings
sorites73825243sorites
specks144312703s_pecks
spicas104715823s_picas
spices104326033s_pices
spick134519073s_pick_
spics94123243s_pic_s
spiks114117473s_pi_ks
splices113914383splices
sprigs94814773spri_gs
springs104415923springs
sprints94113773sprints
sprites94220333sprites
sprits85122533spri_ts
spruces113810503spruces
sris45434153s_ri__s
stack114421693st_ack_
staigs75414813stai_gs
stains64923653stai_ns
stairs65416333stai_rs
stalks104614553st_alks
stances93715963stances
stanks104917703st_anks
statices102712343statices
staticky1743233staticky
statics93314533static_s
steaks104415853st_eaks
steeks103613703st_eeks
steins64818343stei_ns
steric8317063steric__
sterical10311253sterical
stich104117923st_ic_h
sticked144114633st_icked
sticker133515883st_icker
stickers142913033st_ickers
stickies142211973st_ickies
stickit1339463st_ickit
stickle132410973st_ickle
stickles142512103st_ickles
stickum1534823st_ickum
stickums1643943st_ickums
stickup1533853st_ickup
stickups1643303st_ickups
sties55132983st_i_es
stiffs12389963st_iffs
stiles64328773st_iles
stills64118573st_ills
stilts67915313st_ilts
stimes85920573st_imes
stings76220183st_ings
stink95122503st_ink_
stinko10499393st_inko
stinky134611073st_inky
stints65119763st_ints
stipes84524053st_ipes
stirk95717413st_irk_
stirpes95011293stirpes
stirps85011823st_irps
stirs55921623st_i_rs
stock114417563st_ock_
stocky15369153st_ocky
stoic7317253stoic__
stoical9310283stoical
stoicism1246873stoicism
stooks105115373st_ooks
stories7324273stori_es
storks106115953st_orks
strafes104516003strafes
strains74218153strains
straits74916323straits
strake104017393str_ake
strakes114218073strakes
strands83711953strands
straps87721783str_aps
strass67117223str_ass
stratas73013583stratas
straths102711723straths
stratus73011733stratus
straws98718673str_aws
strays96417933str_ays
streak104613623streak_
streaky14447813streaky
streams94713373streams
streek104111413streek_
streels73811343streels
streets73312613streets
streps86218063str_eps
stress66616673str_ess
strews96817103str_ews
stria55723213stri__a
striae65422273stri_ae
striata7379953striata
striate74218953striate
striates83417083striates
strickled1665833strickled
stricter1039423stricter
strictest1147293strictest
strictly1345813strictly
stride75420963stri_de
strider84315723strider
striders94412123striders
stridor8467393stridor
stridors9367323stridors
strife95318363stri_fe
strigil837263strigil
strigils946853strigils
strigose945583strigose
striker113714173striker
strikers123611293strikers
string75327563stri_ng
stringy114111073stringy
strip77524343stri__p
stripe85822443stri_pe
striped105214363striped
striper94514793striper
stripers103911593stripers
stript85222193stri_pt
stripy115812743stri_py
strive95020963stri_ve
strived114713663strived
striven103910753striven
striver104315203striver
strivers113911843strivers
strobes93813263strobes
stroke105116173str_oke
strokes114316323strokes
strolls739183strolls
strook10410303strook_
strops86220383str_ops
strouds837803strouds
strows96718273str_ows
stroys95914603str_oys
strucken1444323strucken
strumas9419833strumas
strums84716453str_ums
strunts7429543strunts
struts65616803str_uts
stuccos1153933stuccos
stuck114515773st_uck_
sucks114523073s__ucks
surimis938843surimis
swinks134610653s_winks
tacks115430133_t_acks
thacks154311923_thacks
thick145613353_thick_
thinks134613363_thinks
tick106231223_t_ick_
tics65729633_t_ic_s
torics85118353toric_s
traces85329933_traces
track114823013_track_
tracts85019073_tracts
traiks104013713_traiks
tranks104017763_tranks
treks96016853_tr_eks
triacs83913223_triacs
triads74513533_triads
trials64319883_trials
tribes85119023_tribes
trice75127493_tric_e
triced95518673_triced
tricep103911073_tricep
triceps11267343_triceps
tricked144016163_tricked
tricker134615523_tricker
trickers143812813_trickers
trickie132611033_trickie
trickish1746793_trickish
trickle133613443_trickle
trickles143013763_trickles
trickly16369893_trickly
tricot8317753_tricot
tricots9311563_tricots
triens65417543_triens
triers64321523_triers
tries55742813_tri_es
trigos74214173_trigos
trigs65423063_tri_gs
trike95320163_tri_ke
trikes105419493_trikes
trills64319853_trills
trims75021473_tri_ms
trines64132563_trines
triols66117803_triols
trios55528093_tri_os
tripacks1664893_tripacks
tripes85324873_tripes
tripos84014923_tripos
trips74923363_tri_ps
troaks104410603_troaks
trock114817603_trock_
truces84916333_truces
truck116115463_truck_
trunks10429753_trunks
tucks114721123_t_ucks
unpicks1545183unpicks
unsticks1436233unst_icks
untracks1437523untracks
upticks1535153upticks
utricle937913utricle
utricles1037223utricles
varices123313573varices
vitrics12198553vitric_s
wicks144619363__wicks
wracks154711113_wracks
wrecks15418883_wrecks
wrick144013393_wrick_
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.423422437.4
2DLD Change Limit1340274076.90619407.3
3Display Results4074070.1402907.1
 (SQL Overall)1786914077.46923924.4
 
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.