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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
beflowering204276(None) 
deflowering1952651deflowering
reflowering1843171reflowering
flowering1636052__flowering
beclowning1843423beclow_ning
bedcovering2052663bedcovering
befingering1843133befingering
befleaing1544023befl__eaing
beflower16166273beflower___
beflowered1942903beflower_ed
beflowers17165823beflower__s
bellowing1547193bellow__ing
bowering142911713b___owering
embowering1863413_embowering
empowering1863253_empowering
glowering1435653__glowering
lowering122210913___lowering
nonflowering1951723nonflowering
reflowing1636523reflow__ing
repowering1645273re_powering
reshowering1843163reshowering
beavering1538704be__avering
beblooding1643244beblo_oding
beclamoring1852534beclamoring
becloaking1944874beclo_aking
beclogging1743414beclo_gging
beclothing1843874beclo_thing
beclouding1644134beclo_uding
becowarding2052534be_cowarding
becrowding1943374becrow_ding
bedcoverings2151244bedcoverings
bediapering1763044bediapering
beflagging1842814befl_agging
beflecking2243034befl_ecking
befogging1773414bef_o_gging
befooling1535054bef_o_oling
befouling1534984bef_o_uling
beglamoring1752684beglamoring
beglooming1642954beglo_oming
behowling1843684be_how_ling
bejeweling2341714be_jeweling
belaboring1544034be_laboring
believing1535284be_l_ieving
bellower13159064bellower___
bellowers14177624bellower__s
belonging1335914be_lo_nging
bescouring1584644besco_uring
beshivering2052544beshivering
besnowing1544124besnow__ing
bestowing1535804bestow__ing
betattering1444144betattering
betokening1742904be_tokening
bettering122212754be__ttering
bewaring14279494be___waring
bewildering1872704bewildering
billowing1545874billow__ing
blowing133813054b__low__ing
bolstering1346874b_olstering
bouldering1464764boul_dering
boweling143410684b___oweling
brokering1636284b__rokering
buffering1835224buf__fering
cowering142514034___cowering
defleaing1444744defl__eaing
deflower15126074deflower___
deflowered1842514deflower_ed
deflowerer1752074deflower_er
deflowerers1851624deflowerers
deflowers16145644deflower__s
delivering1545174de_livering
deploring1337854deplo__ring
dowering132510614___dowering
emboweling1863014_emboweling
fellowing1655924fellow__ing
fleering123811284__fl_eering
flooring12259884__flo_oring
flouring123010144__flo_uring
flowerier1544274__flowerier
flowerily1842994__flowerily
flowing143411764__flow__ing
imbowering1863054_imbowering
impowering1863324_impowering
mellowing1545894mellow__ing
outpowering1743174outpowering
outtowering1542854outtowering
overpowering2144464overpowering
peltering122011674pe_l_tering
powering142210804___powering
realtering1139474real_tering
recovering1647374re_covering
refiltering1544824refiltering
reflexing2035934refl__exing
refloating14198324reflo_ating
reflooding1544054reflo_oding
reflower14126844reflower___
reflowered1742984reflower_ed
reflowers15125984reflower__s
reglowing1436174reglow__ing
replowing1537414replow__ing
resoldering1343994resoldering
sewering122411094se___wering
showering1646404__showering
telfering1336254te_l_fering
telphering1644204te_lphering
towering122610874___towering
upflowing1842934upflow__ing
weltering13219494we_l_tering
yellowing1655074yellow__ing

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 Filter1786911488190.1531167915.0
2DLD Change Limit1488191088.42317668.2
3Display Results1081080.0631714.3
 (SQL Overall)1786911088.63920684.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.