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

117 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
gleamiest123530(None) 
beamiest123212762_beamiest
bleariest1158842bleariest
creamiest13248932creamiest
dreamiest12227222dreamiest
flamiest133111972fl_amiest
gamiest102816222g__amiest
gemmiest13227622g_emmiest
germiest11249912g_ermiest
gladiest101710332gl_adiest
glariest92012522gl_ariest
glaziest18227912gl_aziest
gleamier1144912gleamie_r
gleetiest1035912gleetiest
gloomiest1235602gloomiest
greasiest10208562greasiest
leadiest93314982_leadiest
leafiest113410882_leafiest
leakiest123212792_leakiest
leariest83117842_leariest
leaviest112910812_leaviest
loamiest102310202_loamiest
seamiest102715412_seamiest
sleaziest1836052sleaziest
steamiest1138402steamiest
beadiest113815533_beadiest
beakiest143313463_beakiest
bleakest1436283blea_kest
bloomiest1335853bloomiest
clammiest1535733clammiest
clayiest1337913cl_ayiest
cleanest10310293clea_nest
cleanliest1244353cleanliest
clearest1038653clea_rest
creakiest15238593creakiest
creasiest11229943creasiest
dreariest10229123dreariest
easiest72318773__easiest
elmiest9310743__elmiest
flakiest153210543fl_akiest
flawiest14298573fl_awiest
flaxiest18298183fl_axiest
fledgiest1444183fledgiest
fleeciest1434873fleeciest
fleshiest1576223fleshiest
floatiest1237283floatiest
foamiest13289853_foamiest
freakiest16206693freakiest
gamest94919923g__am_est
gammiest13339323g_ammiest
geekiest13257863g_eekiest
gladdest11145843gl_addest
gladliest1135373gladliest
glairiest1035483glairiest
glassiest10279243glassiest
gleamed11327933gleam_e_d
gleamer10328513gleam_e_r
gleamers11306563gleam_ers
gleaming12277933gleami_ng
gleams94812253gleam__s_
glintiest1037623glintiest
glitziest1944003glitziest
globbiest1444023globbiest
gloppiest1444823gloppiest
glossiest10277943glossiest
gluiest839773gl__uiest
glummest13235563gl_ummest
glumpiest1434943glumpiest
grapiest112211923g_rapiest
greatest939863grea_test
greediest1147553greediest
greeniest1039033greeniest
gremmies1355993gremmies_
grimiest11299823g_rimiest
gummiest13269023g_ummiest
headiest123015553_headiest
heaviest143210443_heaviest
laciest93819033_l_aciest
lakiest113517263_l_akiest
lambiest122410183_l_ambiest
lamest84722763_l_am_est
laziest163814473_l_aziest
leachiest1437243_leachiest
leanest7415863_lea_nest
ledgiest10288593_ledgiest
leeriest83112883_leeriest
leggiest10308233_leggiest
limiest93716103_l_imiest
mealiest102215973_mealiest
meatiest102816793_meatiest
peakiest143512993_peakiest
peatiest103118803_peatiest
phlegmiest1841783phlegmiest
platiest103216083pl_atiest
plumiest122110293pl_umiest
plummiest1544973plummiest
queasiest1844313queasiest
queaziest2743243queaziest
readiest93719043_readiest
rheumiest1442863rheumiest
slatiest82616263sl_atiest
sleekiest1336063sleekiest
sleepiest1136713sleepiest
sleetiest938553sleetiest
slimiest10310743sl_imiest
slummiest1335663slummiest
smeariest1138113smeariest
sneakiest13176833sneakiest
steadiest1038513steadiest
stemmiest1335143stemmiest
streamiest1245113streamiest
sweatiest1238413sweatiest
teariest82417263_teariest
tweakiest1634053tweakiest
uneasiest946563uneasiest
vealiest112513203_vealiest
weariest112914793_weariest

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.423422437.4
2DLD Change Limit1486411177.09320956.0
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.56223630.1
 
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.