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 “hardens” with Change Limit: [1] [2] [3]

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

71 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
hardens11381502(None) 
gardens93312091gardens
harden105718531harden_
harkens144112861harkens
wardens113711901wardens
ardebs937012_ardebs
ardent73022612_ardent
arpens84814822_arpens
bardes95026932barde_s
barrens94414322barrens
burdens1039712burdens
carders104820352carders
cardons104519942cardons
careens94514702careens
darkens12409872darkens
fardels11389892fardels
garden84215082garden_
hades96035112ha_de_s
hadrons113314302hadrons
hagdons1258522hagdons
handers114224332handers
happens14359172happens
haptens124511342haptens
hardass1139752hardass
hardened1338612hardened
hardener1238882hardener
hardeners1338082hardeners
harder105022402harde_r
hardest113118412hardest
hardies114923232hardies
hardness122411082hardness
hardpans1436452hardpans
hards96435652hard__s
hareems12428202hareems
harems115513822har_ems
hares86255542har_e_s
harken135116342harken_
harmers124116592harmers
harmins123716722harmins
harness102413932harness
harpers124916202harpers
harpins123615702harpins
harshens1437602harshens
hastens106214812hastens
hausens1077632hausens
havens124514042ha_vens
hearkens15336692hearkens
heartens113010152heartens
herders113914122herders
hoarders12307432hoarders
hoarsens11306022hoarsens
hoddens12378802hoddens
hoidens11329082hoidens
hordeins1238322hordeins
hordes104921632horde_s
hoydens14347402hoydens
ladens74516232la_dens
larders83516942larders
lardons83914492lardons
maddens11359752maddens
maidens10349662maidens
martens93714952martens
pardons103817622pardons
rehardens13104672rehardens
saddens9309602saddens
sarsens7311392sarsens
sharpens13377812sharpens
warden104515512warden_
warders113416812warders
warrens103810892warrens
yarders113211592yarders

Search took 5 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 Filter1786911076710.390458182.1
2DLD Change Limit107671713.90627565.5
3Display Results71710.0135461.5
 (SQL Overall)178691714.30941469.3
 
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.