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

52 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
bewitcher194300(None) 
bewitched2043231bewitched
bewitchers2042561bewitchers
bewitchery2351661bewitchery
bewitches1943821bewitches
bewitch1743322bewitch__
dowitcher1842592dowitcher
switcher16177682_switcher
twitcher16135342_twitcher
batcher144414853b__atcher
belcher143511493be__lcher
belittler1142493belittler
bencher144113483be__ncher
beseecher1643143beseecher
bewilder1434133bewi_lder
bewitcheries2251473bewitcheries
bewitching2162773bewitching
bewitchment23112283bewitchment
bitched153212923b__itched
bitchen14349733b__itchen
bitchery18236563b__itchery
bitches144117063b__itches
bitchier15307733b__itchier
blither124812173b_lit_her
botcher143613223b__otcher
britches15278683b_ritches
butcher143411163b__utcher
ditcher134012003__ditcher
dowitchers1942133dowitchers
either94517423_e_it_her
etcher113912943_e__tcher
fetcher153510393fe__tcher
hitcher153712003__hitcher
neither1037573ne_it_her
pitcher143813713__pitcher
snitcher13157373_snitcher
stitcher13168393_stitcher
switched17157133_switched
switchers17146633_switchers
switches16159133_switches
swither133710993_swit_her
twitched17155033_twitched
twitchers17134533_twitchers
twitches16156373_twitches
twitchier1753233_twitchier
watcher153113403__watcher
wincher153410653__wincher
witched163012193__witched
witchery19236093__witchery
witches152715793__witches
witchier16307883__witchier
wither124321353__wit_her

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 Filter1786911486410.420425454.8
2DLD Change Limit148641526.92321470.6
3Display Results52520.0134000.0
 (SQL Overall)178691527.35624291.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.