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

38 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
woodsheds174294(None) 
woodshed1644211woodshed_
woolsheds1642551woolsheds
bloodsheds1742142bloodsheds
toolsheds1342322toolsheds
woodhens1534102wood_hens
woolshed1553922woolshed_
wooshed14167402woo_shed_
wooshes13169882woo_she_s
bloodshed1643233bloodshed_
coalsheds1542863coalsheds
cowsheds1734743_cowsheds
moonseeds1243033moonseeds
snowsheds1642873snowsheds
swooshed15174273swoo_shed_
swooshes14185123swoo_she_s
toolshed1244213toolshed_
whooshed1833453whooshed_
whooshes1734423whooshe_s
woodbinds1642793woodbinds
woodchats1842693woodchats
wooded114213683wood__ed_
woodenheads1951403woodenheads
woodhen1454723wood_he_n
woodies113517153wood_ie_s
woodiness13147873woodiness
woodlands1444153woodlands
woodless12278453wood_less
woodshedded216953woodshedded
woodsias1244923woods_ias
woodsier1245473woodsie_r
woodsiest1335203woodsiest
woodsmen1444633woodsme_n
woodwinds1742793woodwinds
woopsed1344733woops_ed_
woopses1237883woops_e_s
wormseeds1542083wormseeds
worsteds1234483w_orsteds

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 Limit148641386.62622433.0
3Display Results38380.0162375.0
 (SQL Overall)178691387.06225303.2
 
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.