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

52 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
awakening174320(None) 
awakenings1841541awakenings
wakening1636321_wakening
awaking1547812awak__ing
reawakening1952192reawakening
rewakening1843792rewakening
wakenings1743042_wakenings
weakening1734842weakening
aliening91510893a_liening
awaiting1238273awa_iting
awaken13468863awake__n_
awakened1653473awaken_ed
awakener1543433awaken_er
awakeners1643093awakeners
awakens14416153awake__ns
awarding1356043awa_rding
aweing103911253aw__e_ing
awning105013393aw___ning
blackening1944793blackening
brazening2185183brazening
cravening1547553cravening
darkening1535683darkening
davening13258873_davening
deadening1277583deadening
deafening1476273deafening
harkening1746923harkening
havening15258553_havening
hearkening1844533hearkening
ladening1078823_ladening
latening9711493_latening
leadening1176733leadening
leavening1365973leavening
likening13246893_likening
neatening1038353neatening
pinkening1634993pinkening
ravening122611293_ravening
sickening1635993sickening
slackening1744343slackening
swanning12338813swa_nning
tokening1336463_tokening
wafering15208893_wafering
wagering13219523_wagering
wagoning1336923_wagoning
waking144821383_wak__ing
waning103623803_wa__ning
wanning113816213_wa_nning
warning113717093_wa_rning
watering122316323_watering
wavering152410543_wavering
weening114113973_w_eening
widening13237833_widening
wizening21255463_wizening

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.440406115.9
2DLD Change Limit148641527.28020417.7
3Display Results52520.0301733.3
 (SQL Overall)178691527.75023056.9
 
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.