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 “awakes” 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
awakes13501247(None) 
awake125014781awake_
awaked14579201awaked
awaken13468861awaken
awakens14416151awakens
wakes126633651_wakes
abakas123911742abakas
abases85720772abases
abates85825032abates
adages8412952adages
agapes95212412agapes
agates76121332agates
agaves104611512agaves
alates64833962alates
amazes175613472amazes
anankes1138762anankes
araks94820882arak_s
arames84622572arames
awaits96411952awaits
awards107113452awards
aware86420022aware_
awes76037552aw__es
awoke124912002awoke_
awoken13457162awoken
bakes117035372_bakes
brakes124923122brakes
cakes116037672_cakes
crakes124921812crakes
drakes114715862drakes
fakes126032482_fakes
flakes134118872flakes
hakes126034302_hakes
jakes165023642_jakes
lakes95737652_lakes
makes115336852_makes
quakes194013342quakes
rakes94440352_rakes
reawakes15348072reawakes
rewakes144614982rewakes
sakes95540752_sakes
shakes135024592shakes
slakes104021882slakes
snakes103919602snakes
stakes103927292stakes
swages104417072swages
swales93920762swales
takes94437792_takes
twaes86513662twa_es
wackes154717712wackes
wades95634142_wades
waes76048602_wa_es
wages95330932_wages
wake114935702_wake_
waked135626752_waked
waken124818472_waken
wakens135012042_wakens
waker125526592_waker
wakers134822492_wakers
wales86142832_wales
wames106432802_wames
wanes85040882_wanes
wares88250582_wares
waves115633922_waves
waxes155825502_waxes

Search took 4 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.1231452772.4
2DLD Change Limit82551643.09326689.6
3Display Results64640.0461391.3
 (SQL Overall)178691643.26254779.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.