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

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

49 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
beguilements1711389(None) 
beguilement16134141beguilement_
befuddlements2261203befuddlements
bemusements1754443bemu_sements
defilements1747073de_filements
requirements2384043requirements
revilements1647133re_vilements
acquirements2552694acquirements
babblements1653394b_abblements
bafflements2183454b_afflements
bailments1346464b__ail_ments
battlements1544964b_attlements
bedazzlements2681334bedazzlements
bedevilments2052474bedevil_ments
bedizenments26102244be_dizenments
befuddlement2161304befuddlement_
beguilers1252884beguil__e_rs
beguiles1146104beguil__e__s
belittlements1772064belittlements
belligerents1562514belligerents
bemusement1645144bemu_sement_
bereavements19154204bereavements
bewilderments2161614be_wilderments
couplements1756194_couplements
debridements1853894debridements
defilement1648074de_filement_
definements1747114de_finements
denudements1545334denu_dements
derailments1446104derail_ments
despisements1785164despisements
devilments1646384de_vil_ments
disguisements1763934disguisements
elements10312174_e___lements
emblements1647794_e_mblements
engulfments1753314engu_lfments
enticements1598164_enticements
entitlements1455104_entitlements
equipments2344024_equi_pments
excitements2254284_excitements
guillemets1362274__guilleme_ts
refinements1646794re_finements
regiments123910324reg_i__ments
requirement2284494requirement_
retirements1357614re_tirements
revilement1548484re_vilement_
securements1545494secu_rements
seducements1654494sedu_cements
settlements1345544se_ttlements
teguments1265454tegu___ments

Search took 7 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 Filter1786911247900.403443402.0
2DLD Change Limit124790496.26619915.4
3Display Results49490.0301633.3
 (SQL Overall)178691496.69926674.3
 
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.