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

98 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
befleaed145466(None) 
defleaed1344951defleaed
beflea1147122beflea__
befleas1236972beflea_s
beflecked2142652beflecked
beleaped1336102be_leaped
deflexed2043882deflexed
reflexed1975252reflexed
beavered1437503beavered
becloaked1843733becloaked
bedewed1437153be_dewed
beefed123510873be__efed
beelined11277713beelined
beeped115313453be__eped
befitted14305723befitted
beflag1265883befl_a_g
beflagged1742423beflagged
beflags1355493befl_ags
befleaing1544023befleaing
befleck1843943befle_ck
beflecks1943753beflecks
beflower16166273beflower
beflowered1942903beflowered
befogged1643153befogged
befooled1434803befooled
befouled1434683befouled
befretted1544373befretted
beglad10138463begl_a_d
behead1239923be_hea_d
beheaded1536373be_headed
belaced124112153be_laced
belated103520013be_lated
belaud939133be_l_aud
belayed133610083be_layed
belched154011843be_lched
beleap10410283be_lea_p
beleaps1138053be_leaps
beleapt11310253be_leapt
belfried1444203belfried
belied95022163be_l_ied
believed14427923believed
belled94626183be_l_led
belleek1347243belle_ek
bellied104314073be_llied
bellowed14158603bellowed
beloved13188393be_loved
belted94020633be_l_ted
bemeaned1335783be_meaned
bereaved1446403be_reaved
beseemed1334853beseemed
besieged1234723besieged
beslaved1435023beslaved
beslimed1335013beslimed
besmeared1443423besmeared
bestead10389113bestea_d
besteaded1345043besteaded
bettered113011833bettered
beveled133811123be_veled
bevelled14327793bevelled
billeted1137643billeted
bleared104211253b__leared
bleated104015973b__leated
bleed85019803b__le_ed
buffered1764993buffered
buffeted1753733buffeted
bulleted1138393bulleted
defeated132812163def_eated
deflated133412303deflated
deflea1037443deflea__
defleas1147223deflea_s
deflected1635983deflected
defueled1374513defueled
delead84112343de_lea_d
deleaded1148333de_leaded
deleaved1346573de_leaved
deleted93314913de_leted
depleted12258723depleted
flexed17419093__flexed
fleyed13408813__fleyed
inflexed1944023inflexed
leafleted1342893leafleted
pelleted1138203pelleted
recleaned1236583recleaned
refeed104717623ref_e_ed
refelled122810163refelled
reflated123514293reflated
reflected1547983reflected
reflexes1865933reflexes
refloated1347013refloated
reflowed15126903reflowed
refluxed1954353refluxed
refueled1286573refueled
released9310243re_leased
replead10399013replea_d
repleaded1336293repleaded
telexed1536323te_lexed
telfered1234883telfered
unflexed1935263unflexed

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.406440125.6
2DLD Change Limit146162986.97020970.2
3Display Results98980.0462130.4
 (SQL Overall)178691987.42224075.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.