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

240 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
wakening163632(None) 
awakening1743201awakening
wakenings1743041wakenings
weakening1734841weakening
awakenings1841542awakenings
darkening1535682darkening
davening13258872davening
harkening1746922harkening
havening15258552havening
ladening1078822ladening
latening9711492latening
likening13246892likening
ravening122611292ravening
rewakening1843792rewakening
tokening1336462tokening
wafering15208892wafering
wagering13219522wagering
wagoning1336922wagoning
waking144821382wak__ing
waning103623802wa__ning
wanning113816212wa_nning
warning113717092wa_rning
watering122316312watering
wavering152410542wavering
weening114113972w_eening
widening13237832widening
wizening21255462wizening
adenine8311213_adenine
ageing84213403_age_ing
agenting1039383_agenting
aliening91510893aliening
alining81917043_alining
amending12308913_amending
aneling82719503_aneling
atoning83514873_atoning
avenging1345863_avenging
awaking1547813awak__ing
aweing103911253_awe_ing
awning105013393_a_wning
baking135626623bak__ing
baning95127833ba__ning
banning103818233ba_nning
barning104320353ba_rning
battening12268853battening
blackening1944793blackening
brazening2185183brazening
cabining1338643cabining
cadencing1544963cadencing
cageling12310843cageling
caking134624673cak__ing
cameoing1379063cameoing
caning94128623ca__ning
cankering162110793cankering
canning103620133ca_nning
capering132414963capering
careening12310013careening
casketing1635383casketing
catering112019903catering
caverning1536283caverning
cozening20188303cozening
cravening1547553cravening
dackering1737383dackering
daikering1536103daikering
damning114211633da_mning
dampening1535463dampening
darning93817333da_rning
dawning124111013da_wning
deadening1277583deadening
deafening1476273deafening
dekeing13358353deke_ing
dizening19177143dizening
dovening13238353dovening
dozening19236183dozening
earning83418213ea_rning
evening11310223_evening
faceting1438783faceting
faking145520983fak__ing
fanning113615073fa_nning
fastening13268603fastening
fattening13287833fattening
fawning14409133fa_wning
gaeing84617223ga_e_ing
gaining94015663ga_ining
gardening1236513gardening
gaveling133410163gaveling
greening103112533greening
haeing104118923ha_e_ing
hankering17239383hankering
happening1735593happening
hardening1438023hardening
hastening13259483hastening
havering152211053havering
hearkening1844533hearkening
jacketing2345643jacketing
keening123713153_keening
kenning124010543__kenning
kerning124010893__kerning
keying1438043__keying
labeling11311643labeling
lacewing1435843lacewing
lackering1639373lackering
lackeying1934923lackeying
lagering102212313lagering
laking115027043lak__ing
lamenting1237693lamenting
layering122310353layering
leadening1176733leadening
leavening1365973leavening
livening12248153livening
maddening1445113maddening
making134823853mak__ing
manning103616383ma_nning
marketing1636513marketing
masoning1139763masoning
neatening1038353neatening
omening10310093_omening
opening1039923_opening
packeting1836853packeting
paining103920243pa_ining
paneling111013623paneling
panning104019393pa_nning
papering132213313papering
parenting12611583parenting
patenting1248943patenting
patining11312303patining
pawning134711413pa_wning
peening103318303_peening
pinkening1634993pinkening
preening113115843preening
queening1846113queening
racketing1647873racketing
raining83922693ra_ining
raking114728423rak__ing
rattening10288763rattening
raveling123414373raveling
ravenings13235183ravenings
ravining12269693ravining
razeeing1834363razeeing
reawakening1952193reawakening
rekeying1637563rekeying
ripening1138573ripening
sabeing102611863sabe_ing
sabering112113743sabering
saddening1245213saddening
saining83621393sa_ining
saning75127643sa__ning
sheening123010803sheening
sickening1635993sickening
skeeing12308853_skeeing
skeining1347073_skeining
skewing15318723_skewing
slackening1744343slackening
swanning12338813swa_nning
tabering112211423tabering
taking114725953tak__ing
tanning83618253ta_nning
tapering112112503tapering
tautening1035843tautening
valeting1238843valeting
vanning113912463va_nning
wabbling16207743wabbling
wadding133711943wa_dding
waddling14237933waddling
waddying17204723waddying
wading114619533wa__ding
waffing173710243wa_ffing
waffling1845423waffling
wafting143911663wa_fting
wagging133313353wa_gging
waggling14197063waggling
waggoning1543593waggoning
waging114318383wa__ging
waifing142910893wa_ifing
wailing113620903wa_iling
wairing113414313wa_iring
waisting123615213waisting
waitering13310713waitering
waiting113618953wa_iting
waiving14329633wa_iving
waken124818473wake__n_
wakened1546873waken_ed
wakener1446913waken_er
wakeners1535843wakeners
wakens135012043wake__ns
wakerife1843673wakerife
waling104525303wa__ling
walking154013303wa_lking
walling113520973wa_lling
waltzing2134263waltzing
wambling16198443wambling
wandering143310983wandering
wangling132310993wangling
wanking154216783wa_nking
wanting114220173wa_nting
wantoning1337083wantoning
wapping153514603wa_pping
warbling14198943warbling
warding123918143wa_rding
waring105029443wa__ring
warking153519573wa_rking
warming133515083wa_rming
warnings12358453wa_rnings
warping133715183wa_rping
warring113717973wa_rring
warsling12198593warsling
washing145119283wa_shing
wasting114422843wa_sting
watching173011173watching
waterings13229253waterings
wattling12258783wattling
wauking153410013wa_uking
wauling112713113wa_uling
waving134018203wa__ving
wawling143810963wa_wling
waxing174215283wa__xing
waxwing2154723wa_xwing
waygoing1633273waygoing
weakling16106763weak_ling
weaning114117193w_eaning
weaponing1545383weaponing
weaseling1335613weaseling
wedeling1338773wedeling
weeding123815213w_eeding
weekending1942233weekending
weeping133613673w_eeping
weeting113816053w_eeting
wending123816843w__ending
wheeling15318593wheeling
wheeping17337103wheeping
wheezing24315383wheezing
whining143311673w_hining
whitening1635103whitening
wining103625053w__ining
winning113516553w_inning
womaning1437643womaning
wonning113210793w_onning
worsening1345553worsening
yakking14376423yak_king
yarning113512953ya_rning
yawning14378343ya_wning

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.1561145455.1
2DLD Change Limit1461622407.68619016.7
3Display Results2402400.0932580.6
 (SQL Overall)1786912407.93522519.3
 
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.