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

107 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
flowerer143545(None) 
flowered1546011flowered
flowerers1544501flowerers
floweret1448081floweret
flowerier1544271flowerier
deflowerer1752072deflowerer
floorer10248072flo_orer
flower124815502flow__er
flowerets1544042flowerets
flowers133413172flower_s
flowery16327782flower_y
flowmeter1743392flowmeter
glowered1345752glowered
lowered112711912_lowered
showerer1436162showerer
alterer72714003al_terer
answerer1144273answerer
beflowered1942903beflowered
blower115316573blow__er
blowers124313593blower_s
blowier1248943blow_ier
blowsier1335063blowsier
blowzier2233413blowzier
bowered133113043_bowered
cleverer1334563cleverer
clovered14187363clovered
clowder13367943clow_der
coherer122912783_coherer
coverer123113523_coverer
cowered133214653_cowered
deflowered1842513deflowered
deflowerers1851623deflowerers
dowered122811553_dowered
falterer11239863falterer
fetterer11207813fetterer
filterer11258143filterer
fingerer12127223fingerer
flatterer12187683flatterer
flavorer1454563flavorer
flawier13378733flaw_ier
fleecer12368033fl_eecer
fleer86020773fl__e_er
fleered11309503fl_eered
fleeter103210363fl_eeter
floater104413353flo_ater
floatier1136983floatier
flockier1745343flockier
flogger12449463flo_gger
flooder11258463flo_oder
floored11268683flo_ored
floorers11227573flo_orers
flopover1642863flopover
flopper14328473flo_pper
floppier1554633floppier
floret9321123flo__ret
flosser10339693flo_sser
flossier11326973flossier
flounder1235103flounder
floured11289873flo_ured
flouter104311343flo_uter
flowage1435723flowage_
flowages1535733flowages
flowed133513763flow__ed
flowerage1643103flowerage
flowerages1743063flowerages
flowerette1652333flowerette
flowerful1852283flowerful
floweriest1644533floweriest
flowerily1842993flowerily
flowering1636053flowering
flowerless1642883flowerless
flowerpot1752863flowerpot
flowmeters1843233flowmeters
flutterer12185263flutterer
forever1338953f_orever
fosterer11239523fosterer
fowler123712583f_ow_ler
frowner13429683frow_ner
frowsier1444903frowsier
frowzier2343313frowzier
glower105114933glow__er
glowers113412093glower_s
hoverer13319823_hoverer
however1634513_however
loiterer837083_loiterer
lowbred13225363_lowbred
lower85830413_low__er
lowers94624923_lower_s
lowery124112713_lower_y
lowlier10338903_lowlier
plower114315063plow__er
plowers123812243plower_s
powderer14245593_powderer
powered132911643_powered
properer1259203properer
reflowered1742983reflowered
showered1537013showered
showerers1545073showerers
slaverer11196993slaverer
sliverer11237633sliverer
slobberer13153443slobberer
slower94016153slow__er
soberer93110353_soberer
solderer947183solderer
towered112911403_towered
towerier1137123_towerier
troweler11106063troweler

Search took 9 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.436409841.7
2DLD Change Limit1461621077.72018932.9
3Display Results1071070.0303566.7
 (SQL Overall)1786911078.18621828.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.