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

159 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
broomiest135691(None) 
bloomiest1335851bloomiest
boomiest122711841b_oomiest
broodiest1237821broodiest
roomiest102611991_roomiest
bloodiest1236662bloodiest
booziest19379262b_ooziest
bronziest2035812bronziest
brookies1459142brookies_
broomier1236872broomie_r
browniest14207122browniest
doomiest112910452_doomiest
drooliest1036342drooliest
droopiest1235742droopiest
gloomiest1235602gloomiest
grooviest1334082grooviest
rookiest122912172_rookiest
roomies93017242_roomies_
rootiest83115592_rootiest
balmiest124110993b_almiest
barmiest125212783b_armiest
beamiest123212763b_eamiest
bionomies1397153bionomies_
bionomist1347113bionomi_st
blockiest1736363blockiest
bloodies11310163bloodies_
bloomier1275783bloomie_r
bloomless1342963bloomless
blottiest11286833blottiest
blousiest1136313blousiest
blowiest1337923b_lowiest
blowsiest1435323blowsiest
blowziest2343673blowziest
boggiest123110933b_oggiest
boniest93318993b__oniest
bonniest10310773b_onniest
boobies113718203b_oobies_
boodies103721443b_oodies_
boogies103719013b_oogies_
bookies133819403b_ookies_
bookrest1436493b_ookrest
boomier113312183b_oomie_r
boomlet112412273b_oomle_t
boomlets12246673b_oomlets
boonies93422483b_oonies_
booties94124613b_ooties_
boskiest14289733b_oskiest
bossiest103112213b_ossiest
boxiest163711983b__oxiest
braggiest13116783braggiest
brainiest11209723brainiest
brakiest143912243br_akiest
branniest11199383branniest
brashiest14359853brashiest
brassiest11369713brassiest
brattiest1148103brattiest
brawliest14177193brawliest
brawniest14197103brawniest
breeziest2035063breeziest
brickiest1737433brickiest
briniest102812323br_iniest
brionies10310543brionies_
broadest1138573br_oadest
brollies1039533brollies_
bromes104719763br_om_es_
bromides13219363br_omides_
bromids12278603br_omids_
bromines122514253br_omines_
bromins112513783br_omins_
bromism1337623br_omi_sm
bromizes21258333br_omizes_
brooches15288193brooches_
broodier1157433broodie_r
broodiness1344653broodiness
broodless1235033broodless
brookie1347373brookie__
brookites1545033brookites_
brooklet1456403brookle_t
brooklets1543683brooklets
broomed124111053broom_e_d
brooming132911143broomi_ng
brooms104915873broom__s_
brownest1398893br_ownest
brownies13189613brownies_
brushiest14297543brushiest
bryonies1336843bryonies_
buxomest1942183buxom_est
choosiest1437323choosiest
chromiest1637783chromiest
creamiest13248933creamiest
croakiest15167173croakiest
crookest1436683croo_kest
croupiest1337053croupiest
crummiest1545563crummiest
dreamiest12227223dreamiest
drossiest1036523drossiest
drowsiest1334993drowsiest
foamiest13289853_foamiest
footiest113514913_footiest
froggiest1434913froggiest
frostiest1239213frostiest
frothiest1537453frothiest
frouziest2143973frouziest
frowsiest1535063frowsiest
frowziest2443483frowziest
goofiest12289393_goofiest
gooiest82813883_goo_iest
gooniest93213003_gooniest
goopiest112710553_goopiest
goosiest92911823_goosiest
grimiest11299823gr_imiest
grodiest10310553gr_odiest
groggiest1235093groggiest
grottiest10147183grottiest
groutiest10147763groutiest
growliest1335583growliest
homiest124116633__homiest
hoodiest122413173_hoodiest
hookiest152712103_hookiest
hootiest113115643_hootiest
kookiest11268133_kookiest
loamiest102310203_loamiest
looniest83313253_looniest
loopiest103011313_loopiest
moodiest112712183_moodiest
mooniest103014173_mooniest
mooriest102812723_mooriest
ooziest163411523__ooziest
prosiest10416523pr_osiest
rammiest12299933_rammiest
rimiest93215853_r_imiest
rockiest142912223_rockiest
roiliest8312283_roiliest
roofies103014413_roofies_
rookies113917103_rookies_
roomie83013873_roomie__
roomier93812243_roomie_r
roominess1157293_roominess
ropiest93317773_r_opiest
rosiest73919213_r_osiest
roupiest102610293_roupiest
rowdiest12259213_rowdiest
rummiest12299353_rummiest
snoopiest11157053snoopiest
snootiest9178743snootiest
snooziest18175383snooziest
sootiest84016753_sootiest
spookiest15156393spookiest
spooniest11178133spooniest
stormiest1137003stormiest
swooniest12176293swooniest
swoopiest14155383swoopiest
troutiest9127803troutiest
woodiest123112073_woodiest
wooliest113011643_wooliest
wooziest20327903_wooziest
wormiest13249543_wormiest
zooiest16199923_zoo_iest
zootiest173311213_zootiest

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411598.07618405.3
3Display Results1591590.0801987.5
 (SQL Overall)1786911598.32921454.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.