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

156 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
broadest113857(None) 
blondest11419242blondest
boldest102613062b_oldest
bravest124211752br_avest
brawest123810482br_awest
broadcast1444872broadcast
broaden10289142broade_n
broadens11267232broadens
broader103412602broade_r
broadish1446932broadish
broadness1256652broadness
broads94515142broad_s_
brocades1358702brocades_
broodiest1237822broodiest
brownest1398892brownest
proudest1138942proudest
abrades10312073abr_ades_
arbalest1039523arbalest
arcades101113193arcades_
aridest8316143ar_idest
baddest112611143b_addest
baldest102313533b_aldest
barest85327693b__arest
basest84720493b__asest
beadiest113815533b_eadiest
blades95221253b_lades_
blandest113811043blandest
bleakest1436283bleakest
blindest11609093blindest
blondes104213163blondes_
bloodiest1236663bloodiest
blowiest1337923blowiest
boast75935703b_oa__st
bodes84935103b_o_des_
boniest93318993b_oniest
bookrest1436493bookrest
boomiest122711843boomiest
booziest19379263booziest
boraces113716853boraces_
borages103917163borages_
boranes93720403boranes_
borates94823013borates_
boraxes163511633boraxes_
borides10515153borides_
boxiest163711983b_oxiest
braces108427773br_aces_
brads85528293br_ad_s_
braes75735053br_a_es_
braggest1296533braggest
brakes124923123br_akes_
brakiest143912243brakiest
braless92910563br_aless
brashest133511763brashest
braves115524083br_aves_
brazes175522193br_azes_
breaded115014063breade_d
breadless1235943breadless
breadnut1144883breadnut
breads95419203bread_s_
breast8319633brea__st
bredes94818473br_edes_
brides94423513br_ides_
briefest1335893briefest
brigades1236393brigades_
briniest102812323briniest
briskest14337803briskest
broaches153211623broaches_
broad84817693broad___
broadax1744453broad_ax
broadaxe1843623broadaxe
broadaxes1943723broadaxes_
broadbean1442673broadbean
broadcasts1553183broadcasts
broadened1364333broadened
broadener1284083broadener
broadleaf1542603broadleaf
broadly1337153broad_ly
broadsheet1653353broadsheet
brocade1238533brocade__
brocaded1436353brocade_d
brocket154013383brocke_t
brockets16328123brockets
brogues10719823brogues_
broider103912973broide_r
broiders114211183broiders
broidery14356083broidery
brokages1536253brokages_
bromates12413133bromates_
bromes104719763bro_mes_
bromides13219363bromides_
bronzes183510403bronzes_
bronziest2035813bronziest
brooded113510933broode_d
brooder103811623broode_r
brooders112610233brooders
broodless1235033broodless
broods95416383brood_s_
broomiest1356913broomiest
broses86524403bro_ses_
browbeat1544883browbeat
browless1346653browless
browniest14207123browniest
browses124712693browses_
bruskest14315903bruskest
byroads1335293byroad_s_
coldest102514753_coldest
croakiest15167173croakiest
crookest1436683crookest
crossest1012012123crossest
crudest104510333cr_udest
deadest93014883_deadest
drollest937353drollest
dryades12395633dryades_
erodent8313823ero_dent
erodes74819883ero_des_
fondest11312403_fondest
goldest92411173_goldest
grades84926313gr_ades_
grandest10311573grandest
gravest114011633gr_avest
grayest11489363gr_ayest
greatest939863greatest
grodiest10310553grodiest
grossest93810093grossest
irades74517393ir_ades_
iratest7312483ir_atest
loudest839933_loudest
modest93818453_mo_dest
oddest81710863__oddest
oldest72114093__oldest
oroides8311973oroides_
prosiest10416523prosiest
protest9317533pro_test
prowest12311533pro_west
rarest65725483_r_arest
rawest93615063_r_awest
readiest93719043_readiest
realest73322433_realest
reddest9311953_reddest
roadeo7510323_roade_o
roadeos837403_roadeos
roadies83317433_roadies_
roadless937693_roadless
roads66523613_road_s_
roast56230143_roa__st
rodent7519243_ro_dent
rodes614039083_ro_des_
ropiest93317773_ropiest
rosiest73919213_rosiest
roundest9310473_roundest
rowdiest12259213_rowdiest
rudest74016313_r_udest
shoalest1168913shoalest
trades75724493tr_ades_
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.186960704.3
2DLD Change Limit1461621569.15615963.5
3Display Results1561560.1101418.2
 (SQL Overall)1786911569.45218905.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.