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

39 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
drumhead154265(None) 
drumheads1642291drumheads
drophead1544612drophead
drumbeat1343972drumbeat
drummed13306322drumme_d
dumbhead17102742d_umbhead
bluehead1444603bluehead
brushed133811213brushe_d
clubhead1662773clubhead
crumbed14378473crumbe_d
crumped144311223crumpe_d
crushed134111973crushe_d
deadhead1444433deadhead
dickhead1944143dickhead
dopehead1544073dopehead
douched144012113douche_d
drammed13378073dramme_d
dread74419023dr___ead
dropheads1643873dropheads
drubbed13406983drubbe_d
drudged11277613drudge_d
drugged11367183drugge_d
drumbeats1442323drumbeats
drumbled14266033drumbled
drummer12407503drumme_r
drummers13316163drummers
druthers1275793druthers
dumbed124012083d_umbe_d
dumbheads1882433d_umbheads
dumped123814493d_umpe_d
grumped13337333grumpe_d
jughead1933643_jughead
redhead1257053_redhead
ruched124314633_ruche_d
rumbaed12287493_rumbaed
rushed104419863_rushe_d
subhead1387693_subhead
trumeau944163trum_eau
trumped12439713trumpe_d

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.420425454.8
2DLD Change Limit146162397.06320694.0
3Display Results39390.0162437.5
 (SQL Overall)178691397.49923828.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.