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

122 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
drunkest133442(None) 
bruskest14315902bruskest
crankest1438142crankest
dankest122611672d_ankest
drunken12263712drunke_n
drunker12326632drunke_r
drunks11427512drunk_s_
dunnest83312262d_unnest
durndest1065762durndest
frankest1536962frankest
punkest132611692_punkest
rankest112713812_rankest
blankest14439063blankest
bluntest1036553bluntest
briniest102812323briniest
briskest14337803briskest
brunet84419293brun_e_t
brunets9419553brun_ets
chunkiest1835263chunkiest
clunkiest1535163clunkiest
crankiest1538823crankiest
crookest1436683crookest
crudest104510333cru_dest
cruelest1059183cruelest
damndest1276003damndest
darkest122512623d_arkest
darndest1067223darndest
daubiest1138233daubiest
densest83112473d_ensest
dinkiest133812873d_inkiest
dourest8312943dou_rest
downiest122710603downiest
drabbest13295663drabbest
drakes114715863dr_akes_
drest65530343dr___est
driest74722753dr__iest
drinker12349483drinke_r
drinkers13277823drinkers
drinks116810713drink_s_
drollest937353drollest
drones75023433dron_es_
drudges10308873drudges_
drugget10337613drugge_t
druggets11313913druggets
druggiest12134973druggiest
druggist11163663druggist
druidess1043083druidess
drumbeat1343973drumbeat
drumliest1235433drumliest
drunk10549843drunk___
drunkard1441553drunkard
drunkenly1751313drunkenly
drupes94912653dru_pes_
druses75517253dru_ses_
dryest104811123dr__yest
dryness11114783dryn_ess
duckiest153211863d_uckiest
dukes105023473d_u_kes_
dullest8312633d_ullest
dumbest1238743d_umbest
dunces95215753d_unces_
dunes65332173d_un_es_
dungiest102810743d_ungiest
dunked124315283d_unke_d
dunker113616463d_unke_r
dunkers123512193d_unkers
dunks105621193d_unk_s_
dunness8298983d_unness
durnedest1144083durnedest
duskiest133710083d_uskiest
funest94316863_fun_est
funfest13348083_funfest
funkiest152810973_funkiest
funnest102912003_funnest
gauntest936603gauntest
grandest10311573grandest
gruffest1544593gruffest
grummest13286363grummest
grunges93310403grunges_
grungiest1135803grungiest
gunkiest132610573_gunkiest
hunkiest153812333_hunkiest
junket173815023_junke_t
junkets18377623_junkets
junkiest192610173_junkiest
lankest112714113_lankest
luniest73516993_luniest
murkest133110203_murkest
pinkest132812623_pinkest
plunkiest1535503plunkiest
prunes83419063prun_es_
puniest92918093_puniest
punkiest149312663_punkiest
renest64529713_ren_est
roundest9310473roundest
rubiest92914423_rubiest
rudest74016313_ru_dest
ruliest72816433_ruliest
rummest11279833_rummest
runes55530223_run_es_
runkles114111943_runkles_
runless72810423_runless
runlet63821413_runle_t
runlets73310773_runlets
runniest82911203_runniest
runtiest83014513_runtiest
skunkiest12135093skunkiest
soundest9510973soundest
spunkiest15166563spunkiest
sunket103721363_sunke_t
sunkets113511283_sunkets
swankest15105933swankest
trinket11314813trinke_t
trinkets1237143trinkets
truest64816193tru__est
trunked12358413trunke_d
trunks10429753trunk_s_
unkent103116053__unkent
unkept123710873__unkept
unrest62918853__unrest
wrongest1236733wrongest
youngest1244903youngest

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.1561145455.1
2DLD Change Limit1461621227.15620425.1
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.35824285.3
 
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.