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

51 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
hearkening184453(None) 
harkening1746921h_arkening
heartening1446731heartening
bedarkening1942192bedarkening
darkening1535682_darkening
hardening1438022h_ardening
hoarsening1444402hoarsening
weakening1734842wea_kening
awakening1743203awa_kening
betokening1742903betokening
blackening1944793blackening
careening12310013_careening
cheapening1883803chea_pening
coarsening1345543coarsening
deadening1277583dea_dening
deafening1476273dea_fening
earning83418213_ear__ning
gardening1236513_gardening
hankering17239383h_ankering
happening1735593h_appening
hardenings1544243h_ardenings
harking154120943h_ark__ing
harshening1744173h_arshening
hastening13259483h_astening
havening15258553h_a_vening
headlining1553773headlining
hearing113324163hear___ing
hearken14338023hearke__n_
hearkened1744453hearken_ed
hearkener1644213hearken_er
hearkeners1743983hearkeners
hearkens15336693hearke__ns
hearsing1239383hear__sing
hearteningly1972433hearteningly
hearting12513123hear__ting
heartrending1762253heartrending
leadening1176733lea_dening
learning978553lear__ning
leavening1365973lea_vening
marketing1636513_marketing
neatening1038353nea_tening
reawakening1952193reawakening
regreening1246033regreening
rehardening1644143rehardening
remarketing1843713remarketing
rewakening1843793rewakening
sharpening1644883sharpening
slackening1744343slackening
smartening1344993smartening
wakening1636323_wa_kening
yearning1296983year__ning

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 Filter1786911406030.406440125.6
2DLD Change Limit140603516.54621479.2
3Display Results51510.0331545.5
 (SQL Overall)178691516.98525582.1
 
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.