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

243 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
thicket16321307(None) 
thicken16317871thicken
thicker163611021thicker
thickest17337301thickest
thickets17287081thickets
thickety20274101thickety
thickset17257131thickset
ticket124524851t_icket
chickee183111552chickee
chicken18278982chicken
cricket154716952cricket
hickey185011992_hickey
picket144924312_picket
pricket153616442pricket
shicker163914822shicker
tacket124627492t_acket
thacked173810202thacked
thick145613352thick__
thickens17266412thickens
thicketed1943612thicketed
thickly19415572thickly
thicks154511992thick_s
thicksets18263732thicksets
thinker143610682thinker
ticked134720522t_icked
ticker124321502t_icker
tickets134113682t_ickets
tricked144016162tricked
tricker134615522tricker
trinket11314812trinket
tucket124219482t_ucket
whicker19359772whicker
wicket155318942_wicket
becket144619883_becket
bicker144819173_bicker
bracket154117233bracket
bricked164312063bricked
brisket134413403brisket
brocket154013383brocket
bucket144620733_bucket
checked193710023checked
checker18329533checker
chicer134513603chic_er
chicest14209943chicest
chick165419133chick__
chickees19258513chickees
chickens19267433chickens
chickpea2143193chickpea
chicks175317593chick_s
chicle134312543chicle_
chicles143512503chicles
chinked174011023chinked
chirked173810333chirked
chirker16429323chirker
chirkest1735383chirkest
chocked194411613chocked
chucked19469733chucked
clicked164112453clicked
clicker154111883clicker
cricked164814283cricked
crickets16418123crickets
crickey18418143crickey
crocket154615673crocket
dicked144920863_dicked
dicker134521403_dicker
dickey165913523_dickey
docket134721173_docket
ethicist1347893ethicist
flicked174610673flicked
flicker163610623flicker
frisket143811773frisket
hacked164923513_hacked
hackee154921833_hackee
hacker154822693_hacker
hick135530303_hick__
hickeys19508223_hickeys
hickie153812473_hickie
hickies163614743_hickies
hicks145322173_hick_s
hike116830393_hi_ke_
hiked135919203_hi_ked
hiker125119393_hi_ker
hikes125426983_hi_kes
hocked165521303_hocked
hocker155118563_hocker
hockey184813153_hockey
hoicked1735963hoicked
icker114018443__icker
jacket194720673_jacket
kicked124415943_kicked
kicker114116183_kicker
licked134621563_licked
licker125222043_licker
locket123922473_locket
mickey174211853_mickey
nicked135019683_nicked
nickel123811343_nickel
nicker123818703_nicker
packet144726503_packet
picked154421313_picked
picker144422173_picker
pickets154314183_pickets
placket15412873placket
pocket144622623_pocket
pricked164613833pricked
pricker154013413pricker
prickets16329083prickets
quicken2235153quicken
quicker2247023quicker
quickest2345343quickest
quickset2345363quickset
racket125229423_racket
ricked136523623_ricked
rickets134915093_rickets
rickety16478313_rickety
rickey154613973_rickey
rocket125425283_rocket
shacked174015393shacked
shickers173012823shickers
shicksa1634103shicksa
shikker13277023shikker
shirked153710463shirked
shirker143711343shirker
shocked174611813shocked
shocker163411433shocker
shucked17389833shucked
shucker163710103shucker
sicked134524403_sicked
sickee124622223_sickee
sicken124615253_sicken
sicker124023903_sicker
sickest131813793_sickest
slicked144413843slicked
slicken13309293slicken
slicker133314533slicker
slickest14229253slickest
snicked143811633snicked
snicker133012673snicker
socket123923523_socket
sticked144114633sticked
sticker133515883sticker
stickit1339463stickit
stricken1436893stricken
tacet75840023t_ac_et
tacked134723943t_acked
tacker124224503t_acker
tackets134914363t_ackets
tackey154613083t_ackey
talcked1446343talcked
tercet83624913terc_et
thack144915173thack__
thacks154311923thack_s
thanked15469153thanked
thanker14309593thanker
thecae11299653thecae_
thecate123210023thecate
thickened1944303thickened
thickener1844163thickener
thickhead2242693thickhead
thickish2044603thickish
thickness1844443thickness
thief114516303thi__ef
thieve1235963thieve_
thieved1434973thieved
thieves1346903thieves
thighed1535273thighed
thine85026863thi_ne_
think125018803think__
thinkers15308703thinkers
thinks134613363think_s
thinned11399163thinned
thinner10358973thinner
thinnest11248893thinnest
thirled11328093thirled
thirst9312253thi_rst
thither13328103thither
thrice114311573thric_e_
thunked15386853thunked
thwacked2132723thwacked
thwacker2042873thwacker
ticced11438443t_icced
tick106231223t_ick__
tickers133617723t_ickers
ticketed15146643t_icketed
tickle124616743t_ickle
tickled144313133t_ickled
tickler133612653t_ickler
tickles133416853t_ickles
ticks115823293t_ick_s
tike85534483t_i_ke_
tikes95628903t_i_kes
tinker103619923t_inker
tippet103917873t_ippet
toilet66228093toi_let
tracked143716133tracked
tracker133515173tracker
trice75127493tric_e_
triced95518673tric_ed
tricep103911073tric_ep
trices84826333tric_es
trick115420693trick__
trickers143812813trickers
trickery17297343trickery
trickie132611033trickie
trickier143010233trickier
trickiest1549023trickiest
trickle133613443trickle
trickled152610433trickled
trickles143013763trickles
trickly16369893trickly
tricks125319013trick_s
tricksy16436583tricksy
tricky154211473trick_y
tricot8317753tric_ot
trijet133916553tri_jet
trike95320163tri_ke_
trikes105419493tri_kes
trinkets1237143trinkets
triolet73219523triolet
triplet94319213triplet
trippet113714113trippet
trivet93721883tri_vet
trocked144312243trocked
trucked143910813trucked
trucker134010733trucker
tucked134017493t_ucked
tucker124316953t_ucker
tuckets134810333t_uckets
twice104711123twic_e_
twinjet1735113twinjet
twinset1039373twinset
whacked20458623whacked
whacker19368503whacker
whickers20297983whickers
whiffet1965343whiffet
whippet17328843whippet
whisked18336913whisked
whisker17367933whisker
whiskey20445583whiskey
wicked164317413_wicked
wicker154518673_wicker
wickets164010943_wickets
wricked174910193wricked

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.436409841.7
2DLD Change Limit1340272436.54620474.6
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.07525256.7
 
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.