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

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

211 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
awakens1441615(None) 
awaken13468861awaken_
awakes135012471awake_s
wakens135012041_wakens
awake125014782awake__
awaked14579202awake_d
awakened1653472awakened
awakener1543432awakener
awakeners1643092awakeners
awaking1547812awaking
awoken13457162awoken_
krakens1034292krakens
reawakens16263432reawakens
rewakens15406242rewakens
waken124818472_waken_
wakers134822492_wakers
wakes126633652_wake_s
weakens14367062weakens
abakas123911743abak_as
abasers95311973abasers
abases85720773abase_s
abaters95115203abaters
abates85825033abate_s
ackees124914583a_ckees
acumens1136953acumens
adages8412953adage_s
agapes95212413agape_s
agates76121343agate_s
agaves104611513agave_s
akees96119243__akees
akene95818663__akene
akenes104817343__akenes
alanins7315803alanins
alans55636173ala__ns
alates64833973alate_s
aliens65619213a_liens
alkanes113812933alkanes
alkene104114003a_lkene
alkenes114212753a_lkenes
amazes175613473amaze_s
amazons1836653amazons
amens75624843__amens
anadems1036143anadems
anankes1138763ananke_s
araks94820883arak__s
arames84622573arame_s
arpens84814823a_rpens
askers105915403a_skers
aspens85013353a_spens
atamans9710433atamans
avens86419333__avens
awaiters1146643awaiters
awaits96411953awa_its
awakening1743203awakening
awakenings1841543awakenings
awardees1243993awardees
awarders1245073awarders
awards107113453awa_rds
aware86420023aware__
awareness1236343awareness
awayness1443303awayness
aweless1038723aweless
awes76037553aw__e_s
awless939263aw_less
awnless1035923awnless
awns75324433aw___ns
awoke124912003awoke__
azaleas1636993azaleas
azans146516883aza__ns
bakers125323453_bakers
bakes117035373_bake_s
beakers134216873beakers
blackens16388103blackens
brackens16327923brackens
brakes124923123brake_s
brazens18418713brazens
cakes116037673_cake_s
canakins142010463canakins
crakes124921813crake_s
cravens124010123cravens
darkens12409873darkens
davens104612913_davens
deadens93410693deadens
deafens11317253deafens
dickens144410133dickens
drakes114715863drake_s
examens1637193examens
fakers134219533_fakers
fakes126032483_fake_s
flakers143613273flakers
flakes134118873flake_s
flamens124611063flamens
gawkers15347453gaw_kers
grabens10367003grabens
hakes126034303_hake_s
harkens144112863harkens
havens124514043_havens
hawkers174210333haw_kers
hawkeys20414703haw_keys
hearkens15336693hearkens
heavens13439303heavens
jakes165023643_jake_s
jawans1657843jawa__ns
kayakers1463613kayakers
kens85435233___kens
khazens2332663khazens
kraken955883kraken_
ladens74516233_ladens
lakers105225153_lakers
lakes95737653_lake_s
latens64620213_latens
lawmakers1843893lawmakers
leadens83610983leadens
leakers113415423leakers
leavens10409303leavens
likens105613703_likens
makers123921733_makers
makes115336853_make_s
manakins14209763manakins
mavens114312973_mavens
neatens73310403neatens
oaken95814383_oaken_
patens84820863_patens
peahens12307573peahens
pinkens13419643pinkens
platens94213983platens
quakers20309693quakers
quakes194013343quake_s
rakees104516973_rakees
rakers104123573_rakers
rakes94440353_rake_s
ravens93916883_ravens
reawaken15345563reawaken_
reawakes15348073reawake_s
rewaken144410273rewaken_
rewakes144614983rewake_s
sakers104125433_sakers
sakes95540753_sake_s
shaken134113613shaken_
shakers144015563shakers
shakes135024593shake_s
sickens134411483sickens
slackens14367713slackens
slakers114115753slakers
slakes104021883slake_s
snakes103919603snake_s
soakers114114953soakers
stakes103927293stake_s
stamens93411483stamens
swagers114211023swagers
swages104417073swage_s
swains94513953swa_ins
swales93920763swale_s
swans84625013swa__ns
swayers13398853swayers
swevens1334613swevens
taken94819143_taken_
takers103923743_takers
takes94437793_take_s
takins105117403_takins
tokens104711563_tokens
twaes86513663twa_e_s
twains95811183twa_ins
tweens9489843tw_eens
wackes154717713wacke_s
waders109120643_waders
wades95634143_wade_s
waes76048603_wa_e_s
wafers124316143_wafers
wagers105122203_wagers
wages95330933_wage_s
wagons103911213_wagons
wains86930873_wa_ins
wake114935703_wake__
waked135626753_wake_d
wakened1546873_wakened
wakener1446913_wakener
wakeners1535843_wakeners
waker125526593_wake_r
waking144821383_waking
walers94824463_walers
wales86142833_wale_s
walkers143411473walkers
wames106432803_wame_s
wanes85040883_wane_s
wankers144514713wankers
wans76452273_wa__ns
wardens113711903wardens
wares88250583_ware_s
warns87231003_wa_rns
warrens103810893warrens
waters95030633_waters
wavers125022473_wavers
waves115633923_wave_s
waveys15597013_waveys
waxen154911813_waxen_
waxers164014303_waxers
waxes155825503_waxe_s
weaken13349603weaken_
weakons14287803weakons
weens85224053_w_eens
wens76337933_w__ens
wheens124610613_wheens
whens114618763_w_hens
widens106212723_widens
wizens186110263_wizens
woken124614973_woken_
wovens12449833_wovens
wrens85016243_w_rens
yamens114010823_yamens
zazens1435833_zazens

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272116.09321996.9
3Display Results2112110.0633349.2
 (SQL Overall)1786912116.56227231.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.