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

57 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
reawaken1534556(None) 
reawake14457891reawake_
reawaked16366621reawaked
reawakens16263431reawakens
reawakes15348071reawakes
reawoken15454841reawoken
rewaken144410271re_waken
awaken13468862__awaken
reawakened1842042reawakened
reawaking17216072reawaking
reawoke14397442reawoke_
retaken113911802re_taken
rewake135218462re_wake_
rewaked153811902re_waked
rewakens15406242re_wakens
rewakes144614982re_wakes
rewoken145112292re_woken
awake125014783__awake_
awaked14579203__awaked
awakens14416153__awakens
awakes135012473__awakes
awoken13457163__awoken
betaken13438283be_taken
hearken14338023hea_rken
reawakening1952193reawakening
redware1139363redware_
redwares1239053redwares
remake124016113re_make_
remaker133813173re_maker
remakes134116173re_makes
reshaven1435193reshaven
resoaked1337943resoaked
respoken14506923respoken
retake104718533re_take_
retaker113714313re_taker
retakes113718863re_takes
rewakened1743443re_wakened
rewaking162310983re_waking
rewan85623663re_wa__n
rewaxed18409343re_waxed
rewaxes173911333re_waxes
rewiden1137533re_widen
rewoke1339521223re_woke_
rewoven13557933re_woven
seawan94111223seawa__n
seaware1049633seaware_
seawares1139333seawares
seawater1136603seawater
teacake1335453teacake_
teacakes1435883teacakes
teamaker1445113teamaker
teaware1048143teaware_
teawares1148083teawares
unawake1445343unawake_
unawaked1635903unawaked
waken124818473___waken
weaken13349603we__aken

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 Filter1786911461620.420425454.8
2DLD Change Limit146162576.56322270.6
3Display Results57570.0301900.0
 (SQL Overall)178691577.01325480.0
 
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.