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

29 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
shepherdess205141(None) 
sheepherders2181632sheepherders
shepherded2052262shepherde_d
shepherdesses226852shepherdesses
shepherds1843222shepherd__s
sheepherder2061883sheepherde_r
sheerness1236273she__erness
shelterless1452043shelterless
shepherd1744373shepherd___
shepherding2152273shepherding
cheerless1495294che__erless
hyphenless2151844_hyphenless
seeress7311574s_e__er_ess
sewerless1244304s_e_werless
shapeless1435574shap_e_less
sheepheads1943664sheephead__s
sheepherding2251894sheepherding
sheepherdings2361254sheepherdings
sheerest11310084she__er_est
sheerlegs1343294she__erlegs
sheetless1235824she__etless
shelterers1344344shelter_ers
showerless1642544sh_owerless
shutterless1452134shutterless
slenderness1243454slenderness
spheres123114354s__pher_e_s
spheriest1438384s__pheriest
stewardess1442264ste_wardess
sweaterdress166764sweaterdress

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 Filter1786911488190.453394461.4
2DLD Change Limit148819298.81316886.3
3Display Results29290.0161812.5
 (SQL Overall)178691299.28219251.3
 
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.