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

155 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
flowered154601(None) 
flowerer1435451flowerer
floweret1448081floweret
glowered1345751glowered
lowered112711911_lowered
beflowered1942902beflowered
bowered133113042_bowered
clovered14187362clovered
cowered133214652_cowered
deflowered1842512deflowered
dowered122811552_dowered
fleered11309502fl_eered
floored11268682flo_ored
floured11289872flo_ured
flowed133513762flow__ed
flower124815502flower__
flowerers1544502flowerers
flowerets1544042flowerets
flowerier1544272flowerier
flowers133413172flower_s
flowery16327782flower_y
lowbred13225362_lowbred
powered132911642_powered
reflowered1742982reflowered
showered1537012showered
towered112911402_towered
altered83215733al_tered
answered1235493answered
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
deflowerer1752073deflowerer
doweled12269773_doweled
embowered1743413embowered
empowered1743053empowered
faltered122810983faltered
fathered151510433fathered
fendered13258673fendered
festered122512103festered
fettered12259493fettered
fevered14339723f_evered
fibered1337643f_ibered
filtered12259043filtered
fingered13128333fingered
flared105317603fl__ared
flattered13188623flattered
flavored1554573flavored
flawed134712723flaw__ed
fleeced13358153fl_eeced
fleeted113310233fl_eeted
flexed17419093fl__exed
fleyed13408813fl__eyed
flickered1943753flickered
flittered13196253flittered
floated113312703flo_ated
flocced15365483flo_cced
flocked174510253flo_cked
flogged13528803flo_gged
flooded12307933flo_oded
floorer10248073flo_orer
flopped15338763flo_pped
floreated1346573floreated
floret9321123flo__ret
florid10311453flo__rid
flossed11388533flo_ssed
flounced1433803flounced
floundered1542423floundered
flouted113210813flo_uted
flowage1435723flowage_
flowages1535733flowages
flowerage1643103flowerage
flowerages1743063flowerages
flowerette1652333flowerette
flowerful1852283flowerful
floweriest1644533floweriest
flowerily1842993flowerily
flowering1636053flowering
flowerless1642883flowerless
flowerpot1752863flowerpot
flowmeter1743393flowmeter
flustered13185883flustered
fluttered13185943fluttered
foddered1434553foddered
fostered122210453fostered
fowled133914103f_ow_led
frogeyed1642783frogeyed
froward1436673frowar_d
frowned14348833frow_ned
frowsted1534313frowsted
fullered1236383fullered
glowed114913833glow__ed
glower105114933glower__
glowers113412093glower_s
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
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 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621556.53022383.2
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.04625360.6
 
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.