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
gleamiest123531(None) 
beamiest123212762_beamiest
bleariest1158852bleariest
creamiest13248932creamiest
dreamiest12227222dreamiest
flamiest133111982fl_amiest
gamiest102816232g__amiest
gemmiest13227632g_emmiest
germiest11249922g_ermiest
gladiest101710342gl_adiest
glariest92012532gl_ariest
glaziest18227922gl_aziest
gleamier1144912gleamie_r
gleetiest1035912gleetiest
gloomiest1235602gloomiest
greasiest10208562greasiest
leadiest93314992_leadiest
leafiest113410892_leafiest
leakiest123212802_leakiest
leariest83117852_leariest
leaviest112910822_leaviest
loamiest102310212_loamiest
seamiest102715422_seamiest
sleaziest1836062sleaziest
steamiest1138412steamiest
beadiest113815533_beadiest
beakiest143313463_beakiest
bleakest1436283blea_kest
bloomiest1335853bloomiest
clammiest1535743clammiest
clayiest1337923cl_ayiest
cleanest10310293clea_nest
cleanliest1244363cleanliest
clearest1038653clea_rest
creakiest15238593creakiest
creasiest11229943creasiest
dreariest10229123dreariest
easiest72318773__easiest
elmiest9310743__elmiest
flakiest153210553fl_akiest
flawiest14298583fl_awiest
flaxiest18298193fl_axiest
fledgiest1444183fledgiest
fleeciest1434873fleeciest
fleshiest1576233fleshiest
floatiest1237293floatiest
foamiest13289853_foamiest
freakiest16206693freakiest
gamest94919933g__am_est
gammiest13339333g_ammiest
geekiest13257873g_eekiest
gladdest11145843gl_addest
gladliest1135383gladliest
glairiest1035493glairiest
glassiest10279253glassiest
gleamed11327933gleam_e_d
gleamer10328513gleam_e_r
gleamers11306563gleam_ers
gleaming12277933gleami_ng
gleams94812253gleam__s_
glintiest1037623glintiest
glitziest1944003glitziest
globbiest1444023globbiest
gloppiest1444833gloppiest
glossiest10277943glossiest
gluiest839773gl__uiest
glummest13235563gl_ummest
glumpiest1434953glumpiest
grapiest112211933g_rapiest
greatest939863grea_test
greediest1147553greediest
greeniest1039033greeniest
gremmies1355993gremmies_
grimiest11299823g_rimiest
gummiest13269033g_ummiest
headiest123015553_headiest
heaviest143210443_heaviest
laciest93819043_l_aciest
lakiest113517273_l_akiest
lambiest122410193_l_ambiest
lamest84722763_l_am_est
laziest163814483_l_aziest
leachiest1437253_leachiest
leanest7415863_lea_nest
ledgiest10288593_ledgiest
leeriest83112883_leeriest
leggiest10308233_leggiest
limiest93716103_l_imiest
mealiest102215973_mealiest
meatiest102816793_meatiest
peakiest143513003_peakiest
peatiest103118813_peatiest
phlegmiest1841783phlegmiest
platiest103216093pl_atiest
plumiest122110293pl_umiest
plummiest1544973plummiest
queasiest1844313queasiest
queaziest2743243queaziest
readiest93719043_readiest
rheumiest1442863rheumiest
slatiest82616273sl_atiest
sleekiest1336073sleekiest
sleepiest1136723sleepiest
sleetiest938563sleetiest
slimiest10310753sl_imiest
slummiest1335673slummiest
smeariest1138123smeariest
sneakiest13176843sneakiest
steadiest1038523steadiest
stemmiest1335143stemmiest
streamiest1245123streamiest
sweatiest1238423sweatiest
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 Limit1486411176.93621430.4
3Display Results1171170.0631857.1
 (SQL Overall)1786911177.42224075.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.