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

123 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
drowsiest133499(None) 
drossiest1036521drossiest
frowsiest1535061frowsiest
blowsiest1435322blowsiest
browniest14207122browniest
dowdiest13328952d_owdiest
downiest122710602d_owniest
drawliest13166242drawliest
dressiest1036822dressiest
drooliest1036342drooliest
droopiest1235742droopiest
dropsies1138692dropsies_
drowses114610232drows_es_
drowsier1284902drowsie_r
drowsiness1443642drowsiness
frowstiest1643082frowstiest
frowziest2443482frowziest
growliest1335582growliest
prosiest10416522pro_siest
rosiest73919212_ro_siest
rowdiest12259212_rowdiest
artsiest879653ar_tsiest
blousiest1136313blousiest
blowiest1337923blow_iest
blowziest2343673blowziest
bossiest103112213_bossiest
brassiest11369713brassiest
brawliest14177193brawliest
brawniest14197103brawniest
bronziest2035813bronziest
broodiest1237823broodiest
broomiest1356913broomiest
brownest1398893brow_nest
brownies13189613brownies_
browses124712693brows_es_
choosiest1437323choosiest
cosiest93819853_co_siest
cowiest123614673_cow_iest
crawliest14187403crawliest
creasiest11229943creasiest
croakiest15167173croakiest
crossest1012012123cro_ssest
croupiest1337063croupiest
crowdies1437543crowdies_
crowsfeet1743233crowsfeet
dewiest11312343d_ew_iest
ditsiest92111323d_itsiest
dodgiest11308713d_odgiest
doggiest113410523d_oggiest
doomiest112910453d_oomiest
dopiest103315993d_o_piest
dorkiest133111253d_orkiest
dotiest83717453d_o_tiest
dottiest92611393d_ottiest
dowdies123412733d_owdies_
dowries114413983d_owries_
dowses105718303d_ows_es_
doziest174012473d_o_ziest
draffiest1644353draffiest
draftiest1335943draftiest
draggiest12126413draggiest
dreamiest12227223dreamiest
dreariest10229123dreariest
dreggiest12124543dreggiest
driest74722753dr___iest
driftiest1335943driftiest
drippiest1445363drippiest
drollest937353dro_llest
dropsied1234963dropsie_d
droskies13186343droskies_
drosses84513823dro_sses_
drossier956313drossie_r
drouthiest1443913drouthiest
drowse105010553drows_e__
drowsed12448743drows_e_d
drowsily1583723drowsi_ly
drowsing13287773drowsi_ng
druggiest12134973druggiest
drumliest1235423drumliest
flossiest12296803flossiest
froggiest1434913froggiest
frostiest1239213frostiest
frothiest1537453frothiest
frouziest2143973frouziest
frowsier1444893frowsie_r
glossiest10277943glossiest
goosiest92911823_goosiest
gorsiest92511133_gorsiest
grassiest10309513grassiest
greasiest10208563greasiest
grodiest10310553gro_diest
groggiest1235093groggiest
grooviest1334083grooviest
grossest93810093gro_ssest
grottiest10147183grottiest
groutiest10147763groutiest
growthiest1742883growthiest
horsiest112513263_horsiest
jowliest18247623_jowliest
lousiest82311613_lousiest
lowliest11229473_lowliest
mossiest103112443_mossiest
mousiest102711763_mousiest
newsiest11107483_newsiest
noisiest839763_noisiest
nosiest73415673_no_siest
prissiest11178903prissiest
prossies101515223prossies_
prowest12311533prow__est
rockiest142912223_rockiest
roiliest8312283_roiliest
rookiest122912173_rookiest
roomiest102611993_roomiest
rootiest83115593_rootiest
ropiest93317773_ro_piest
roupiest102610293_roupiest
rowdies113112693_rowdies_
showiest1438783show_iest
snowiest1138133snow_iest
sonsiest8313033_sonsiest
tressiest937883tressiest
troutiest9127803troutiest
woodsiest1335203woodsiest

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 Limit1486411237.84318952.1
3Display Results1231230.0631952.4
 (SQL Overall)1786911238.07922118.0
 
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.