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

136 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
thickest1733730(None) 
thicket163213071thicke_t
thickets17287081thickets
thickset17257131thickset
chicest14209942chic_est
chirkest1735382chirkest
quickest2345342quickest
sickest131813792_sickest
slickest14229252slickest
thicken16317872thicke_n
thickens17266412thickens
thicker163611022thicke_r
thickety20274102thickety
thickish2044602thickish
thickness1844442thickness
thicks154511992thick_s_
thicksets18263732thicksets
thinnest11248892thinnest
ticket124524852t_icke_t
tickets134113682t_ickets
trickiest1549022trickiest
blackest16269303blackest
brickiest1737433brickiest
briskest14337803briskest
chichiest1936343chichiest
chickee183111553chicke_e
chickees19258513chickees
chicken18278983chicke_n
chickens19267433chickens
chicks175317593chick_s_
chicles143512503chicles_
chicness1535593chicness
chiefest1645313chiefest
chillest13259593chillest
chinkiest1867023chinkiest
choicest15226453choic_est
cricket154716953cricke_t
crickets16418123crickets
diciest103316523_diciest
dickiest153412503_dickiest
ethicist1347893ethic_ist
ficklest17267903_ficklest
hickey185011993_hicke_y
hickeys19508223_hickeys
hickies163614743_hickies_
hickish1936473_hickish
hicks145322173_hick_s_
highest1439563_highest
hikes125426983_hi_kes_
hinkiest153311753_hinkiest
hippest14219753_hippest
iciest82914743__iciest
ickiest133611043__ickiest
juiciest1736923juiciest
kickiest13319673_kickiest
likest104914383_li_kest
micklest16219123_micklest
mirkest13309723_mirkest
nicest82315663_nic_est
picket144924313_picke_t
pickets154314183_pickets
pickiest162712593_pickiest
pinkest132812623_pinkest
priciest122112903priciest
pricket153616443pricke_t
prickets16329083prickets
prickiest1748183prickiest
quickset2345363quickset
richest122813683_richest
rickets134915093_rickets
shicker163914823shicke_r
shickers173012823shickers
shicksa1634103shick_sa
shiest95821523shi__est
shiniest113212493shiniest
shtickiest1943283shtickiest
slackest14289393slackest
spiciest122711603spiciest
stickiest15229603stickiest
strictest1147293strictest
tacket124627493t_acke_t
tackets134914363t_ackets
tackiest143112433t_ackiest
thacked173810203thacke_d
thacks154311923thack_s_
thewiest14196343thewiest
thick145613353thick___
thickened1944303thickened
thickener1844163thickener
thicketed1943613thicketed
thickhead2242693thickhead
thickly19415573thick_ly
thieves1346903thieves_
thinker143610683thinke_r
thinkers15308703thinkers
thinks134613363think_s_
thinness11277163thinness
thirst9312253thi__rst
thymiest1634733thymiest
ticked134720523t_icke_d
ticker124321503t_icke_r
tickers133617723t_ickers
tickles133416853t_ickles_
ticks115823293t_ick_s_
tidiest83514873t_idiest
tikes95628903t_i_kes_
tiniest73020123t_iniest
trices84826333tric_es_
tricked144016163tricke_d
tricker134615523tricke_r
trickers143812813trickers
trickery17297343trickery
trickish1746793trickish
trickles143013763trickles_
trickliest1646433trickliest
tricks125319013trick_s_
tricksiest1644353tricksiest
tricksy16436583trick_sy
triggest1036923triggest
trikes105419493tri_kes_
trimmest12227023trimmest
trinket11314813trinke_t
trinkets1237143trinkets
tritest7315273tri_test
tucket124219483t_ucke_t
tuckets134810333t_uckets
twiniest1147153twiniest
wackest164710863_wackest
whackiest2144983whackiest
whicker19359773whicke_r
whickers20297983whickers
whiniest14298753whiniest
whitest133710113whi_test
whitiest14259883whitiest
wicket155318943_wicke_t
wickets164010943_wickets

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621367.11020557.2
3Display Results1361360.0602266.7
 (SQL Overall)1786911367.61023481.1
 
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.