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

125 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
drumliest123542(None) 
crumbiest1536252crumbiest
crumbliest1643892crumbliest
crummiest1545562crummiest
crumpliest1644112crumpliest
drawliest13166242drawliest
drooliest1036342drooliest
druggiest12134972druggiest
drumlier1134522drumlie_r
drumlins1144992drumlins_
dumpiest1338742d_umpiest
frumpiest1634542frumpiest
grumpiest1435022grumpiest
ruliest72816422_ru_liest
rummiest12299352_rummiest
rumpliest1345302_rumpliest
brambliest1643773brambliest
brawliest14177193brawliest
brumbies1436533brumbies_
brushiest14297543brushiest
bulliest104314493_bulliest
bumpiest1437873_bumpiest
burbliest1365583burbliest
burliest103113053_burliest
chummiest1834643chummiest
clumpiest1535343clumpiest
clumsiest1335393clumsiest
crampiest15268613crampiest
crawliest14187403crawliest
crimpiest15237183crimpiest
cruddiest1334453cruddiest
cruelest1059183cruel_est
cruellest1155583cruellest
crummies1437643crummies_
crustiest112410053crustiest
curliest102713113_curliest
dangliest1137173dangliest
darkliest1435163darkliest
daubiest1138233dau_biest
deadliest1138183deadliest
dimpliest1436583dimpliest
doomiest112910453doom_iest
doughiest1435783doughiest
draffiest1644353draffiest
draftiest1335943draftiest
draggiest12126413draggiest
dreamiest12227223dreamiest
dreariest10229123dreariest
dreggiest12124543dreggiest
dressiest1036823dressiest
driest74722753dr___iest
driftiest1335943driftiest
drippiest1445363drippiest
drizzliest19122533drizzliest
drollest937353dr_ollest
droopiest1235743droopiest
drossiest1036523drossiest
drouthiest1443913drouthiest
drowsiest1334993drowsiest
druggies11126223druggies_
druggist11163663druggi_st
drumbeat1343973drum_beat
drumbles13277723drumbles_
drumfires1542553drumfires_
drumfish1743503drumfi_sh
drumlike1543793drumli_ke
drumlin1044423drumli__n
drunkest1334423dru_nkest
dualist8614053d_uali_st
duckiest153211863d_uckiest
duelist8511413d_ueli_st
dullest8312633d_u_llest
dumbest1238743d_um_best
dummies123012133d_ummies_
dungiest102810743d_ungiest
duskiest133710083d_uskiest
dustiest93015073d_ustiest
frilliest1237113frilliest
fruitiest1237383fruitiest
fumiest12312193_fum_iest
glumpiest1434943glumpiest
grimiest11299823grim_iest
grisliest1047353grisliest
growliest1335583growliest
grubbiest1434253grubbiest
gruffiest1634523gruffiest
grummest13286363grum_mest
grungiest1135803grungiest
gummiest13269023_gummiest
haulmiest1443813haulmiest
humpiest1538963_humpiest
jumpiest1936863_jumpiest
knurliest1344063knurliest
loudliest1035763loudliest
lumpiest1239253_lumpiest
plumiest122110293plum_iest
plummiest1544973plummiest
rammiest12299933_rammiest
rimiest93215853_rim_iest
roiliest8312283_roiliest
rubbliest1354683_rubbliest
rubiest92914423_ru_biest
ruddiest10278543_ruddiest
ruffliest1554483_ruffliest
rummest11279833_rum_mest
rummies113212793_rummies_
runniest82911203_runniest
runtiest83014513_runtiest
rushiest113312923_rushiest
rustiest83116803_rustiest
ruttiest82712663_ruttiest
scummiest1535203scummiest
seemliest1145613seemliest
slummiest1335653slummiest
spumiest1238193spum_iest
studliest1036563studliest
stumpiest1335843stumpiest
surliest82416903_surliest
thrummiest1742093thrummiest
trampiest13227893trampiest
trembliest1443633trembliest
trustiest9239083trustiest
ugliest8410143__ugliest
unruliest945863unru_liest
yummiest15256723_yummiest

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411257.67019379.5
3Display Results1251250.0502500.0
 (SQL Overall)1786911257.89322639.2
 
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.