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

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

51 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
befuddlements226120(None) 
befuddlement2161301befuddlement_
beguilements17113893begu_ilements
bafflements2183454baf__flements
bedazzlements2681334bedazzlements
befuddles1642024befuddl__e__s
beguilement16134144begu_ilement_
belittlements1772064belittlements
bemusements1754444bemu__sements
defilements1747074def__ilements
denudements1545334denu_d_ements
babblements1653395b__abblements
bafflement2074165baf__flement_
battlements1544965b__attlements
bedazzlement2581545bedazzlement_
bedevilments2052475bedevil_ments
bedizenments26102245be__dizenments
befuddle1542105befuddl__e___
befuddled1742005befuddl__e__d
befuddling1841855befuddl__in_g
belittlement1682495belittlement_
bemuddles1542455bemuddl__e__s
bemusement1645145bemu__sement_
bereavements19154205be_reavements
bewilderments2161615bewilderments
bodements1447615b___od_ements
couplements1756195_cou_plements
debridements1853895debrid_ements
defacements1946075def__acements
defilement1648075def__ilement_
definements1747115def__inements
deforcements2054665def_orcements
denudement1445895denu_d_ement_
effacements2154875_ef_facements
elements10312175_e____lements
emblements1647795_e__mblements
enfeeblements2062215enfeeblements
ennoblements1654125_ennoblements
entitlements1455105_entitlements
fundaments1653865__fund_aments
judgements2153165__ju_dgements
puzzlements2352235__puzzlements
refinements1646795ref__inements
requirements2384045requ_irements
resettlements1553215resettlements
revilements1647135re__vilements
ruddlemen1352115__ruddlemen__
securements1545495secu__rements
seducements1654495se__ducements
settlements1345545se__ttlements
supplements1754595__supplements

Search took 10 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.423422437.4
2DLD Change Limit124790518.59314522.3
3Display Results51510.0301700.0
 (SQL Overall)178691519.04619753.6
 
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.