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 “waken” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 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
waken12481847(None) 
awaken13468861awaken
oaken95814381oaken
taken94819141taken
wake114935701wake_
waked135626751waked
wakens135012041wakens
waker125526591waker
wakes126633651wakes
waxen154911811waxen
weaken13349601weaken
woken124614971woken
akee85936812_akee
akene95818662_akene
akin86328032_akin
amen66733152_amen
awake125014782awake_
awaked14579202awaked
awakens14416152awakens
awakes135012472awakes
awoken13457162awoken
bake105637512bake_
baked126130772baked
baker115629542baker
bakes117035372bakes
cake105439962cake_
caked126128622caked
cakes116037672cakes
cakey145517272cakey
darken114013442darken
daven94916472daven
dawen95413722dawen
eaten55323052eaten
fake115534942fake_
faked135225482faked
faker124824592faker
fakes126032482fakes
fakey155515422fakey
gaen57329602ga_en
haen76229452ha_en
hake115637842hake_
hakes126034302hakes
harken135116342harken
haven114718532haven
jake155925772jake_
jakes165023642jakes
ken76343982__ken
kraken955882kraken
laden65022192laden
lake85741602lake_
laked105731122laked
laker95432872laker
lakes95737652lakes
laten54328342laten
liken911818842liken
make105537882make_
maker114127812maker
makes115336852makes
maven104816892maven
naked105320852naked
oaten55222402oaten
paten74827342paten
rake84841572rake_
raked105831422raked
rakee96031172rakee
raker94529792raker
rakes94440352rakes
ramen75625192ramen
raven84723442raven
rewaken144410272rewaken
sake85244962sake_
saker95132022saker
sakes95540752sakes
shaken134113612shaken
take84739262take_
taker95229002taker
takes94437792takes
takin94921302takin
token95419312token
wacke145918622wacke_
wacker154920122wacker
wackes154717712wackes
wade85237062wade_
waded106024752waded
wader95325362wader
wades95634142wades
wae67556952wa_e_
waes76048602wa_es
wafer114417642wafer
wage84834082wage_
waged104822782waged
wager95925052wager
wages95330932wages
wagon94312952wagon
wain75840192wa_in
wakened1546872wakened
wakener1446912wakener
wakers134822492wakers
waking144821382waking
wale74546432wale_
waled94330992waled
waler84229262waler
wales86142832wales
walked145313782walked
walker133913992walker
wame95035482wame_
wames106432802wames
wan66761932wa__n
wane76344712wane_
waned95831782waned
wanes85040882wanes
waney115120322waney
wanked144517152wanked
wanker134219972wanker
warden104515512warden
ware76254722ware_
wared96339872wared
wares88250582wares
warked144421212warked
warn75239322wa_rn
warren95012852warren
water84733312water
wauked144210572wauked
wave105234732wave_
waved125223582waved
waver115025702waver
waves115633922waves
wavey145115542wavey
waxed166018482waxed
waxer154317482waxer
waxes155825502waxes
weakens14367062weakens
weaker134015442weaker
weakon13357622weakon
ween75835462w_een
wen66249602w__en
wheen115016052wheen
when105723042w_hen
widen94717972widen
wizen175813862wizen
woke115527962woke_
women104619252women
woven115215172woven
wren78221682w_ren
yamen104115182yamen
zazen1337282zazen

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001461.84329191.5
3Display Results1461460.0334424.2
 (SQL Overall)1786911461.96990752.2
 
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.