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

144 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
brownest139889(None) 
browniest14207121browniest
blowiest1337922blowiest
brawest123810482braw_est
brawniest14197102brawniest
broadest1138572broadest
browbeat1544882browbeat
browless1346652browless
browned134710972browne_d
browner124911642browne_r
brownies13189612brownies_
brownish1645642brownish
brownness1444342brownness
brownout1345682brownout
browns116415632brown_s_
browses124712692browses_
crownet123714112crowne_t
crownets13407672crownets
prowest12311532prow_est
baroness101210063baro_ness
baronet91022203baro_ne_t
baronets101410903baro_nets
baronnes1038553baronnes_
barrenest1149563barrenest
blondest11419243blondest
blowiness1435623blowiness
blowsiest1435323blowsiest
blowziest2343673blowziest
boldest102613063b_oldest
bones76446533b_o_nes_
boneset9316433b_o_neset
boniest93318993b_oniest
bonnes85621453b_onnes_
bonnet85524633b_onne_t
bonnets94812803b_onnets
bonniest10310773b_onniest
bookrest1436493bookrest
boomiest122711843boomiest
booziest19379263booziest
boranes93720403boranes_
bowless123310313b_owless
bowses115718863b_owses_
boxiest163711983b_oxiest
braggest1296533braggest
brainiest11209723brainiest
brakiest143912243brakiest
branniest11199383branniest
brashest133511763brashest
bravest124211753br_avest
brawliest14177193brawliest
brawns115614083brawn_s_
briefest1335893briefest
brines85028853br_ines_
briniest102812323briniest
briskest14337803briskest
broadness1256663broadness
brocket154013383brocke_t
brockets16328123brockets
brogues10719823brogues_
bromes104719763bro_mes_
bromines122514253bromines_
broncs101611153bro_ncs_
bronzes183510403bronzes_
bronziest2035813bronziest
broodiest1237823broodiest
broomiest1356913broomiest
broses86524403bro_ses_
browbeats1642893browbeats
browed125216393brow_e_d
brown105619533brown___
brownie12178433brown_ie
brownier13226913brownier
browning14299643browning
brownnose1442583brownnose
brownouts1443113brownouts
browny144510043brown__y
brows105425983brow__s_
browse115713853brow__se
browsed134511233browse_d
browser124911143browse_r
browsers13449203browsers
brunet84419293br_une_t
brunets9419553br_unets
bruskest14315903bruskest
cowiest123614673_cowiest
crones84729243cro_nes_
crookest1436683crookest
crossest1012012123crossest
crowfeet1645563crowfeet
crowned133912433crowne_d
crowner124012603crowne_r
crowners133710753crowners
crownless1443423crownless
crowns115615113crown_s_
downiest122710603_downiest
drollest937353drollest
drones75023433dro_nes_
drownds12346153drownds_
drowned12419903drowne_d
drowner11369803drowne_r
drowners12428273drowners
drowns105612333drown_s_
drowses114610233drowses_
drowsiest1334993drowsiest
frowned14348833frowne_d
frowner13429683frowne_r
frowners14377933frowners
frowns126011393frown_s_
frowsiest1535063frowsiest
frowst125512073frow__st
frowziest2443483frowziest
greenest9312623greenest
grodiest10310553grodiest
grossest93810093grossest
growliest1335583growliest
groynes1137823groynes_
honest94822423_ho_nest
irones64724013iro_nes_
ironist7314843iro_nist
ironness836953ironness
lowest93915593_low_est
lowness1037813_lowness
nowness1037033_nowness
prosiest10416523prosiest
protest9317533pro_test
proudest1138943proudest
prowess1237903prow_ess
rawest93615063_raw_est
rawness1038153_rawness
renest64529713_r_enest
ropiest93317773_ropiest
rosiest73919213_rosiest
roundest9310473_roundest
rowdiest12259213_rowdiest
rowens94515303_rowens_
showiest1438793showiest
slowest10168713slow_est
slowness1135013slowness
snowiest1138143snowiest
soonest7415593_soonest
trapnest10310923trapnest
trones65629283tro_nes_
urbanest10117533urbanest
wrongest1236733wrongest

Search took 10 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.436409841.7
2DLD Change Limit1461621449.20315882.0
3Display Results1441440.0632285.7
 (SQL Overall)1786911449.70218418.0
 
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.