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

103 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
gruffiest163453(None) 
gruffest1544591gruff_est
buffiest1657562_buffiest
chuffiest2044402chuffiest
draffiest1644362draffiest
fluffiest1434092fluffiest
grubbiest1434252grubbiest
gruffier1544702gruffie_r
gruffish1843942gruffi_sh
gruffness1692742gruffness
grumpiest1435022grumpiest
grungiest1135802grungiest
gulfiest1247952g_ulfiest
huffiest1757202_huffiest
puffiest1647322_puffiest
ruffliest1554492_ruffliest
scruffiest1842932scruffiest
snuffiest15246052snuffiest
stuffiest15235952stuffiest
bluffest1664643bluff_est
brushiest14297543brushiest
buffest15298643_buff_est
chaffiest2045413chaffiest
chuffest1944193chuff_est
cliffiest1743953cliffiest
craftiest1436913craftiest
cruddiest1334453cruddiest
crumbiest1536253crumbiest
crummiest1545563crummiest
crustiest112410053crustiest
daffiest1537843_daffiest
draftiest1335943draftiest
driftiest1335943driftiest
druggiest12134973druggiest
drumliest1235433drumliest
fruitiest1237383fruitiest
frumpiest1634543frumpiest
gaudiest1039393gau_diest
gauziest1836233gau_ziest
gluiest839773glu__iest
glumpiest1434943glumpiest
goofiest12289393g_oofiest
goutiest93013883gou_tiest
grabbiest1435323grabbiest
graffitist1752393graffitist
grainiest10188993grainiest
grapiest112211923gr_apiest
grassiest10309513grassiest
greasiest10208563greasiest
greediest1147553greediest
greeniest1039033greeniest
griffes14367923griff_es_
griffins1544783griffins_
grimiest11299823gr_imiest
gripiest11289633gr_ipiest
grippiest1435143grippiest
grisliest1047353grisliest
grittiest10176983grittiest
grodiest10310553gr_odiest
groggiest1235093groggiest
grooviest1334083grooviest
grottiest10147183grottiest
grouchiest1644123grouchiest
groutiest10147763groutiest
growliest1335583growliest
gruffed1544943gruff_e_d
gruffer1475793gruff_e_r
gruffily1863083gruffi_ly
gruffing1635273gruffi_ng
gruffs13337453gruff__s_
grummest13286363gru_mmest
gulpiest1137353g_ulpiest
gummiest13269023g_ummiest
gunkiest132610573g_unkiest
gushiest123510983g_ushiest
gustiest92914523g_ustiest
gutsiest92610583g_utsiest
guttiest92311223g_uttiest
iffiest1337963__iffiest
miffiest1637133_miffiest
reefiest112811483_reefiest
rubiest92914423_ru_biest
ruddiest10278543_ruddiest
ruffes124112423_ruff_es_
ruffles133512273_ruffles_
ruliest72816433_ru_liest
rummiest12299353_rummiest
runniest82911203_runniest
runtiest83014513_runtiest
rushiest113312923_rushiest
rustiest83116803_rustiest
ruttiest82712663_ruttiest
scurfiest14236863scurfiest
sniffiest15236003sniffiest
snuffliest1643503snuffliest
spiffiest17235653spiffiest
squiffiest2542663squiffiest
surfiest112414433_surfiest
truffes1356773truff_es_
truffles1485593truffles_
trustiest9239083trustiest
tuftiest1138283_tuftiest
turfiest112410133_turfiest

Search took 7 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.1701051123.5
2DLD Change Limit1486411036.55022693.3
3Display Results1031030.0432395.3
 (SQL Overall)1786911036.76326421.9
 
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.