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

138 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
beldames133680(None) 
beldame1237231beldame_
beldams1237051beldam_s
bedamns1235732be_damns
bedlamps1543662bedlamps
bedlams1237052bedlam_s
beladies11310422beladies
beldam11410112beldam__
benames112814602be_names
beshames1537202beshames
blames105121862b_l_ames
mesdames1346042mesdames
aceldamas1472263aceldamas
balases93815433bal_ases
baldies105317703bald_ies
baldpates1445233baldpates
ballades114211643ballades
ballgames1443573ballgames
balsamed1344543balsamed
balsams11579013balsam_s
bandages12310633bandages
beadles103414733bead_les
beadmen12299453bead_men
beadsmen1385883beadsmen
beamed115720733be__amed
beams95328173be__am_s
became123213163be_came_
bechamel1754283bechamel
bechamels1853033bechamels
becomes132911963be_comes
becrimes1467073becrimes
bedamn1137813be_dam_n
bedamned1434583be_damned
bedaubs1233693be_daubs
bedemen12910183be_demen
bedframes1743013bedframes
bedims1149593be_dim_s
bedlam1149273bedlam__
bedlamites1542733bedlamites
bedlamp1464513bedlam_p
bedmates1349183bedmates
bedrapes1386963bedrapes
bedtimes1336593bedtimes
bedumbs1433633be_dumbs
beedies10314203beed_ies
begazes1937963be_gazes
begrimes1376513begrimes
behaves15198523be_haves
belaced124112153bel_aced
beladied1236663beladied
belated103520013bel_ated
belauds1036643bel_auds
belayed133610083bel_ayed
belayer12339503bel_ayer
belayers13298143bel_ayers
belays114313853bel_a_ys
belches143514343bel_ches
beleaped1336103beleaped
beleaps1138053belea_ps
belfries1336983belfries
belgas9311713belga__s
belies84631053bel__ies
believes13449403believes
belles85325993bel__les
bellies94023723bel_lies
bellmen1138143bel_lmen
bemadamed1742193bemadamed
bemadams1543383bemadam_s
bename103316073be_name_
benamed122911093be_named
bendayed1534873bendayed
bendays13327513benda_ys
bendees103913863bend_ees
berakes134815773be_rakes
berates94126873be_rates
berdaches1745053berdaches
bereaves1338273bereaves
berhymes1843803berhymes
berimes115216643be_rimes
bermes106023003be__rmes
beshame1447483beshame_
beshamed1635733beshamed
beslimes1246953beslimes
betakes134212523be_takes
betimes115114413be_times
bewares12313373be_wares
blades95221253b_l_ades
blame95625493b_l_ame_
blamed116017953b_l_amed
blamer104417143b_l_amer
blamers115314213b_l_amers
blams95023853b_l_am_s
blares85021633b_l_ares
blazes174817353b_l_azes
blumes105917793b_l_umes
bolases93315003bol_ases
boldfaces1793223boldfaces
bondages1237893bondages
bulkages1535273bulkages
bullaces12299433bullaces
bynames14256243b_ynames
dames85435853___dames
defames132812253de_fames
degames113312623de_games
delates83526283del_ates
deleaves1248063deleaves
delimes10314193del_imes
elates65032363_el_ates
eluates72014683_eluates
endgames1245423_endgames
fellates11312753fellates
flames114723693_fl_ames
gelates83219593gel_ates
gendarmes1343923gendarmes
lames75445543__l_ames
madames12310063_madames
melamed1249633mel_amed
meltages1148243meltages
pelages10714613pel_ages
pennames12287793pennames
reclames12310893reclames
redates83423873re_dates
reframes1338993reframes
relaces93420883rel_aces
relates73731433rel_ates
relaxes143215323rel_axes
releases8313343releases
relumes9612513rel_umes
renames92418053re_names
sedates83418043se_dates
selvages1236513selvages
sesames9310743se_sames
stepdames1443333stepdames
telomes9310533tel_omes
velamen1237123vel_amen
vendaces1457183vendaces
welcomes15134753welcomes
welfares1445543welfares

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.436409841.7
2DLD Change Limit1461621387.18620339.8
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.66823303.5
 
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.