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

164 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
thickets1728708(None) 
thickens17266411thickens
thickest17337301thickest
thicket163213071thicket_
thickety20274101thickety
thicksets18263731thicksets
tickets134113681t_ickets
chickees19258512chickees
chickens19267432chickens
crickets16418122crickets
hickeys19508222_hickeys
pickets154314182_pickets
prickets16329082prickets
rickets134915092_rickets
shickers173012822shickers
tackets134914362t_ackets
thicken16317872thicke_n
thicker163611022thicke_r
thicketed1943612thicketed
thickness1844442thickness
thicks154511992thick__s
thickset17257132thickset_
thinkers15308702thinkers
tickers133617722t_ickers
ticket124524852t_icket_
trickers143812812trickers
trinkets1237142trinkets
tuckets134810332t_uckets
whickers20297982whickers
wickets164010942_wickets
beckets15399823_beckets
bickers154316553_bickers
brackets163310433brackets
briskets14346563briskets
brockets16328123brockets
buckets153811693_buckets
checkers19317843checkers
chicest14209943chic_est
chickee183111553chicke_e
chicken18278983chicke_n
chickpeas2242963chickpeas
chicks175317593chick__s
chicles143512503chicle_s
chicness1535593chicness
chirkest1735383chirkest
clickers163910203clickers
cricket154716953cricket_
crockets16339543crockets
dickens144410133_dickens
dickers144117663_dickers
dickeys17479303_dickeys
dockets144412243_dockets
ethicists1445443ethicists
flickers17338883flickers
friskets15326263friskets
hackees165014103_hackees
hackers164619043_hackers
hickey185011993_hicke_y
hickies163614743_hickies
hicks145322173_hick__s
hikers135014353_hi_kers
hikes125426983_hi_ke_s
hockers163915913_hockers
hockeys19509273_hockeys
ickers123914183__ickers
jackets205011373_jackets
kickers124013293_kickers
knickers13306723knickers
lickers134118253_lickers
lockets134612203_lockets
mickeys18447943_mickeys
nickels13338653_nickels
nickers134415093_nickers
packets155114773_packets
pickers153718093_pickers
picket144924313_picket_
plackets1646583plackets
pockets154612253_pockets
prickers163710673prickers
pricket153616443pricket_
quickens2334253quickens
quickest2345343quickest
quicksets2442383quicksets
rackets134916873_rackets
rickety16478313_rickety
rickeys16548983_rickeys
rockets134615363_rockets
shicker163914823shicke_r
shicksas1743523shicksas
shikkers14326523shikkers
shirkers15319583shirkers
shockers17319463shockers
shuckers17388133shuckers
sickees134514213_sickees
sickens134411483_sickens
sickest131813793_sickest
slickens14317263slickens
slickers143112553slickers
slickest14229253slickest
snickers143010963snickers
sockets134012983_sockets
stickers142913033stickers
tackers134319623t_ackers
tacket124627493t_acket_
tercets93512443terc_ets
thacked173810203thacke_d
thacks154311923thack__s
thankers15297833thankers
thick145613353thick___
thickened1944303thickened
thickener1844163thickener
thickeners1943463thickeners
thickhead2242693thickhead
thickheads2342493thickheads
thickish2044603thickish
thickly19415573thick_ly
thieves1346903thieve_s
thinker143610683thinke_r
thinks134613363think__s
thinners11327763thinners
thinness11277173thinness
thinnest11248903thinnest
thirsts1036243thi_rsts
thwackers2142223thwackers
ticked134720523t_icke_d
ticker124321503t_icke_r
ticketed15146643t_icketed
ticklers14339303t_icklers
tickles133416853t_ickles
ticks115823293t_ick__s
tikes95628903t_i_ke_s
tinkers113517143t_inkers
tippets11339373t_ippets
toilets74112913toi_lets
trackers143512853trackers
triceps11267343tric_eps
trices84826333tric_e_s
tricked144016163tricke_d
tricker134615523tricke_r
trickery17297343trickery
trickiest1549023trickiest
trickles143013763trickles
tricks125319013trick__s
tricots9311563tric_ots
trijets14308263tri_jets
trikes105419493tri_ke_s
trinket11314813trinket_
triolets83410143triolets
triplets103510263triplets
trippets12357423trippets
trivets103911583tri_vets
truckers14279013truckers
tuckers134014353t_uckers
tucket124219483t_ucket_
twinjets1842413twinjets
twinsets1133663twinsets
whackers20326543whackers
whicker19359773whicke_r
whiffets2072523whiffets
whippets18255253whippets
whiskers18306773whiskers
whiskeys21353383whiskeys
wickers164114703_wickers
wicket155318943_wicket_

Search took 9 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 Filter1786911461620.466383457.1
2DLD Change Limit1461621647.65619091.2
3Display Results1641640.0632603.2
 (SQL Overall)1786911648.18521831.5
 
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.