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

147 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
glowered134575(None) 
flowered1546011flowered
lowered112711911_lowered
bowered133113042_bowered
clovered14187362clovered
cowered133214652_cowered
dowered122811552_dowered
flowerer1435452flowerer
floweret1448082floweret
glowed114913832glow__ed
glower105114932glower__
glowers113412092glower_s
lowbred13225362_lowbred
powered132911642_powered
showered1537012showered
towered112911402_towered
altered83215733al_tered
answered1235493answered
beflowered1942903beflowered
blazered2035063blazered
bloodred1234083bloodred
blowed125016693blow__ed
blower115316573blower__
blowers124313593blower_s
blowsed13449023blow_sed
blowzed22435973blow_zed
boweled132810693_boweled
brokered1536083brokered
chowdered1944013chowdered
clavered14187633clavered
clobbered16164103clobbered
closeted1135613closeted
closured11266353closured
clotured11246163clotured
cloured103111543clo_ured
clowned13447733clow_ned
cohered133514693_cohered
coopered133310933coopered
covered133315293_covered
deflowered1842513deflowered
doweled12269773_doweled
embowered1743413embowered
empowered1743053empowered
fleered11309503fl_eered
floored11268683flo_ored
floured11289873flo_ured
flowed133513763flow__ed
flower124815503flower__
flowerers1544503flowerers
flowerets1544043flowerets
flowerier1544273flowerier
flowers133413173flower_s
flowery16327783flower_y
gandered112211173gandered
garnered10247113garnered
gartered10319583gartered
gathered13149373gathered
gendered11258873gendered
gettered10258613gettered
gibbered1444303gibbered
gingered11127743gingered
glaceed1136193glace_ed
glaciered1343863glaciered
glaired9387743gl_aired
glandered1236333glandered
glared84715193gl__ared
gleed75320573gl__e_ed
gleeked13346333gl_eeked
gleeted9379323gl_eeted
gleyed11478153gl__eyed
glimmered1543103glimmered
glistered11176293glistered
glittered11195403glittered
gloated93511533glo_ated
globated1265753globated
globed104811763glo__bed
glomera1035943glomer_a
glommed13265443glo_mmed
gloomed11337413glo_omed
glopped13347613glo_pped
gloried9169513glo_ried
glossed94410073glo_ssed
glouted9429713glo_uted
gloved114811873glo__ved
glover104513533glover__
glovers114310883glover_s
glowering1435653glowering
glozed173711223glo__zed
goffered1634523goffered
gomerel1036393g_omerel
gored75227083g_o__red
governed1335193g_overned
gowaned1235763g_owaned
gowned114410133g_ow_ned
groveled13345453groveled
grower104614933grower__
growers113612723grower_s
growled12278173grow_led
gulfweed1641953gulfwe_ed
gumweed1433943gumwe_ed
guttered10259163guttered
hollered1237603hollered
homered133212713_homered
hoovered15195413hoovered
hovered143411573_hovered
imbowered1742553imbowered
impowered1743143impowered
lagered92311153_lagered
lawyered1534033_lawyered
layered11259413_layered
leered73816223_l_eered
levered114212303_levered
livered113111633_livered
loitered938183_loitered
loppered13326753_loppered
loured74617403_lo_ured
louvered1244993_louvered
louvred11354663_louvred
lowed95233903_low__ed
lower85830413_lower__
lowers94624923_lower_s
lowery124112713_lower_y
moldered1237173moldered
overed102216623__overed
plowed124213203plow__ed
plower114315063plower__
plowers123812243plower_s
powdered15256893_powdered
reflowered1742983reflowered
repowered1544663repowered
rogered939553_rogered
roweled11269863_roweled
scowdered1643743scowdered
sewered112911243_sewered
showerer1436163showerer
skewered1634213skewered
slavered12188033slavered
slivered12218103slivered
slobbered14144223slobbered
slowed104617073slow__ed
slower94016153slower__
sobered102912433_sobered
soldered1038153soldered
toweled112410223_toweled
troweled12106113troweled
ulcered1037973ul_cered
widowered1742753widowered

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621476.20323563.1
3Display Results1471470.0632333.3
 (SQL Overall)1786911476.68626726.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.