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

64 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
awaked1457920(None) 
awake125014781awake_
awaken13468861awaken
awakes135012471awakes
waked135626751_waked
aahed917816442a_ahed
abased96514992abased
abated95918452abated
alated75625152alated
amazed18519312amazed
arcked136211942arcked
asked106919312a_sked
awaited1146962awaited
awakened1653472awakened
awakens14416152awakens
award97118042awa_rd
awarded1236222awarded
aware86420022aware_
awed88436032aw__ed
awned96615952aw_ned
awoke124912002awoke_
awoken13457162awoken
baked126130772_baked
beaked135919492beaked
braked135318692braked
caked126128622_caked
faked135225482_faked
flaked144715652flaked
gawked15468762gaw_ked
hawked174712672haw_ked
kayaked1474052kayaked
laked105731122_laked
leaked114217702leaked
naked105320852_naked
peaked136117402peaked
quaked203910032quaked
raked105831422_raked
reawaked16366622reawaked
rewaked153811902rewaked
slaked114318272slaked
snaked115017592snaked
soaked114717592soaked
staked114621942staked
swacked173110522swacked
swaged114212252swaged
swanked15359542swanked
swayed133510262swayed
tweaked1534402tweaked
unawaked1635902unawaked
waded106024752_waded
waged104822782_waged
wake114935702_wake_
waken124818472_waken
waker125526592_waker
wakes126633652_wakes
waled94330992_waled
walked145313782walked
waned95831782_waned
wanked144517152wanked
wared96339872_wared
warked144421212warked
wauked144210572wauked
waved125223582_waved
waxed166018482_waxed

Search took 6 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 Filter178691825510.690258972.5
2DLD Change Limit82551644.85616999.8
3Display Results64640.0331939.4
 (SQL Overall)178691645.57932029.2
 
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.