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

71 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
beflowers1716582(None) 
beflower16166281beflower_
bellowers14177621bellowers
deflowers16145641deflowers
reflowers15125981reflowers
beflowered1942902beflowered
bellflowers1952262bellflowers
bellower13159072bellower_
bestowers14135332bestowers
blowers124313592b__lowers
deflower15126082deflower_
flowers133413172__flowers
reflower14126852reflower_
balloters1157673balloters
beckoners1744063beckoners
beclowns1544683beclow_ns
bedcovers1783563bedcovers
befingers1544103befingers
befleas1236973befl__eas
beflowering2042763beflowering
befoulers1443123befoulers
beholders1544933beholders
belayers13298143be_layers
belchers153510023be_lchers
beliers94617383be_l_iers
bellflower1852413bellflower_
bellowed14158613bellowe_d
bellows124313303bellow__s
beloveds14153963be_loveds
belows114614183be_low__s
belters93819413be_l_ters
bestower13126213bestower_
blower115316573b__lower_
boilovers1444103boilovers
borrowers1474033borrowers
bowers115523703b___owers
burrowers1483503burrowers
coneflowers19113153coneflowers
dayflowers2052413dayflowers
deflaters13298703deflaters
deflowered1842513deflowered
deflowerer1752073deflowerer
deflowerers1851623deflowerers
deplorers1245463deplorers
deployers1545063deployers
elopers95112943_e_lopers
embowers15236453_embowers
empowers15276843_empowers
endowers1238233_endowers
flower124815503__flower_
flowery16327783__flowery
followers15146183followers
geologers1143623geologers
globeflowers2161113globeflowers
glowers113412093__glowers
hallowers15137723hallowers
leftovers1542783leftovers
lowers94624923___lowers
mayflowers2152473mayflowers
mellower13167413mellower_
plowers123812243__plowers
reflowed15126913reflowe_d
reflowered1742983reflowered
reflows13258983reflow__s
repowers13288533re_powers
reshowers15145473reshowers
safflowers1942803safflowers
sunflowers1683263sunflowers
wallowers15127653wallowers
willowers15166693willowers
yellower14186223yellower_

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.453394461.4
2DLD Change Limit148641716.98621277.0
3Display Results71710.0302366.7
 (SQL Overall)178691717.46923924.4
 
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.