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 “beflower” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
beflower1616628(None) 
beflowers17165821beflowers
bellower13159071bellower
deflower15126081deflower
reflower14126851reflower
beflowered1942902beflowered
bellflower1852412bellflower
bellowed14158612bellowed
bellowers14177622bellowers
bestower13126212bestower
blower115316572b__lower
deflowers16145642deflowers
flower124815502__flower
mellower13167412mellower
reflowed15126912reflowed
reflowers15125982reflowers
yellower14186222yellower
balloter1078893balloter
beckoner1654963beckoner
beclown1435423beclow_n
beclowned1743253beclowned
beclowns1544683beclowns
bedcover1663563bedcover
befinger1434643befinger
beflea1147123befl__ea
befleaed1454663befleaed
beflowering2042763beflowering
befooled1434803befooled
before11410153bef_ore_
befouler1343923befouler
beholder1435053beholder
belayer12339503be_layer
belcher143511493be_lcher
belier84423563be_l_ier
bellflowers1952263bellflowers
bellow114213353bellow__
bellows124313303bellow_s
beloved13188393be_loved
below104617193be_low__
belows114614183be_low_s
belter84720963be_l_ter
besnowed14124413besnowed
bestowed14156623bestowed
bestowers14135333bestowers
billowed14137063billowed
billowier1444293billowier
blowed125016693b__lowed
blowers124313593b__lowers
blowier1248943b__lowier
boilover1344023boilover
borrower1384843borrower
bower107328183b___ower
burrower1374273burrower
callower13159073callower
coneflower1873213coneflower
dayflower1942543dayflower
deflater123211603deflater
deflowered1842513deflowered
deflowerer1752073deflowerer
deplorer1136343deplorer
deployer1445633deployer
eloper85414153_e_loper
embower14267413_embower
empower14217033_empower
endower1138483_endower
fellowed15136843fellowed
flowed133513763__flowed
flowers133413173__flowers
flowery16327783__flowery
follower14137073follower
geologer1044483geologer
globeflower2061163globeflower
glower105114933__glower
hallower14139823hallower
hollower14127403hollower
leftover1442713leftover
lower85830413___lower
mayflower2042723mayflower
mellowed14166933mellowed
plower114315063__plower
reflow12379653reflow__
reflowered1742983reflowered
reflown13316213reflow_n
reflows13258983reflow_s
reglowed13125863reglowed
replowed14127583replowed
repower12329883re_power
reshower14107063reshower
safflower1842993safflower
sallower11139503sallower
slower94016153__slower
sunflower1563553sunflower
upflowed1742893upflowed
wallower14158943wallower
willower14127463willower
yellowed15185753yellowed

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.420425454.8
2DLD Change Limit146162966.87621256.8
3Display Results96960.0303200.0
 (SQL Overall)178691967.32624391.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.