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

261 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
avenged124550(None) 
avenge1087551avenge_
avenger1135491avenger
avenges1157541avenges
venged114011991_venged
agented939422agented
amended11328312amended
avengers1235582avengers
avenses1049642avenses
avenue957952avenue_
avenues1057182avenues
averaged1356212averaged
averred11237592averred
averted112211612averted
davened124610072daven_ed
evened101010312even_ed
havened14429242haven_ed
ravened115012282raven_ed
revenged1337552revenged
scavenged1642152scavenged
unavenged1443662unavenged
vegged124910022_vegged
vended114416352_vended
venge95117992_venge_
venges104015152_venges
vented104617922_vented
verged114815162_verged
abetted1058323abetted
absented1156613absented
accented13107773accented
acned87520673a_cn_ed
adeemed1145393adeemed
adenoid959253adenoid
advanced1543313advanced
advected1534533advected
adverted1336103adverted
aeried74221873a_eried
afeared1176833afeared
aged67334253a___ged
agene65621583agen_e_
agenes74720253agen_es
agenized19257733agenized
akene95818663aken_e_
akenes104817343aken_es
alerted82512223alerted
aliened81011743alien_ed
aligned9128553aligned
alined75221403alin_ed
alleged9389323alleged
amend85717753amen__d
amender10349613amender
amerced1256523amerced
aneared8512743aneared
aneled74719283ane_led
angel65019573a__ngel
anger66225883a__nger
angled84219093a__ngled
annexed1535753annexed
anted66328243a__nted
appended1435483appended
arene55329413aren_e_
arenes64928393aren_es
arranged1036933arranged
ascended1246513ascended
assented957513assented
atoned75417543aton_ed
attended1035763attended
availed1135973availed
avengeful1651373avengeful
avenging1345863avenging
avens86419333aven__s
average1158853average_
averages1249183averages
averse95811183averse_
averter102410553averter
aviated11310263aviated
avoided1235553avoided
avowed1335963av_owed
avulsed1133833avulsed
awned96615953a_wn_ed
awninged1342433awninged
banged104923733_banged
begged115013813_begged
bended105521233_bended
binged105920823_binged
blended114710713blended
blunged114310133blunged
bonged105719603_bonged
bunged105218793_bunged
cadenced1435523cadenced
caveated1439133caveated
caverned1436163caverned
cayenned1443163cayenned
censed94016323_censed
changed144214143changed
clanged114212653clanged
clinged113310093clinged
cravened1476723craven_ed
cringed113312403cringed
danged94819493_danged
denied84318633_denied
denned84215633_denned
dented84120513_dented
dinged95221783_dinged
diverged14256883diverged
dovened12389063doven_ed
dredged11346893dredged
dunged95414693_dunged
edged85514533__edged
egged85114393__egged
emended11329603emended
emerged11158213emerged
ended74421263__ended
evangel1134303evangel
evener91010623even_er
everted112711853everted
evinced1335403evinced
fanged114318233_fanged
fenced124412713_fenced
fended114216913_fended
flanged123810843flanged
fledged13417863fledged
flensed1136613flensed
fringed123611523fringed
ganged94619203_ganged
gaveled12399133gave_led
gavelled13387363gavelled
gonged97115913_gonged
hanged114222403_hanged
havered144011453have_red
hedged125211813_hedged
henge94819833_henge_
henges104516463_henges
hented104218753_hented
hinged114618923_hinged
invented122510663invented
kedged13439753_kedged
keened114013633keen_ed
kegged13469263_kegged
kenned114411273_kenned
kinged124215293_kinged
kvelled15276063kvelled
ladened979053laden_ed
lamented1138193lamented
latened8711923laten_ed
laveered1235253laveered
lavender1235143lavender
leavened1235553leaven_ed
legged95713093_legged
lensed74015473_lensed
livened11238933liven_ed
longed87121373_longed
lounged9468243lounged
lunged85418273_lunged
mended104418683_mended
mensed93916543_mensed
merged104214953_merged
omened93711003omen_ed
opened94311863open_ed
overaged13511673overaged
overbed132811853overbed
overed102216623ove_red
overfed142510253overfed
panged104722343_panged
parented11912213parented
patented1188893patented
paveed12438893pave__ed
peened94318163peen_ed
pegged114811913_pegged
pended103819013_pended
penned94217613_penned
pinged104321383_pinged
pledged12358633pledged
plunged11439523plunged
ponged105619353_ponged
pranged114512553pranged
preaged11612333preaged
pronged113912393pronged
ranged84824323_ranged
ravaged1236493rav_aged
raveled114113633rave_led
ravelled12419783ravelled
ravener104110743raven_er
ravined115411823ravin_ed
rended84524103_rended
reneged92010763_reneged
rented74426593_rented
revenge1138573revenge_
revenger1237303revenger
revenges1238983revenges
revenued1237223revenued
ringed84623843_ringed
savaged1236993sav_aged
scavenge1442813scavenge_
scavenger1542193scavenger
scavenges1542903scavenges
scended11329873scended
scented102811883scented
sended85121233_sended
sensed73918163_sensed
serged84118773_serged
sieged85212713sie_ged
singed85422293_singed
slanged94112853slanged
sledged103610333sledged
sponged1137953sponged
stanged94113853stanged
swinged123810793swinged
talented938423talented
tanged84622513_tanged
teenaged10105133teenaged
tended83819483_tended
tenge65720453_tenge_
tensed74817833_tensed
tented74221003_tented
thonged12376843thonged
tinged84220813_tinged
tonged86518913_tonged
trended94011763trended
twanged12387283twanged
twinged12398363twinged
unended92811823unended
upended11267323upended
vaned94622423_van_ed
vanned104614483_vanned
vaunted11438863vaunted
vealed103916323_vealed
veered103612743_veered
veges94118873_ve_ges
veiled103714543_veiled
veined104413913_veined
venae85920983_venae_
vend86626423_ven__d
vendee105617263_vendee
vender103418423_vender
veneer94511693_veneer
venomed1336653_venomed
venter94218723_venter
venue84918213_venue_
venues95115203_venues
verge93419843_verge_
verger104315703_verger
verges104320183_verges
versed104515523_versed
vested104217353_vested
vetoed10359823_vetoed
vetted104316323_vetted
vexed165713113_ve_xed
vined95626153_vin_ed
wakened1546873waken_ed
wavered142910433wave_red
wedged125110303_wedged
weened104013733ween_ed
wended113616153_wended
whanged15447613whanged
whinged15409153whinged
winged114620833_winged
wringed123710193wringed
wronged12397673wronged
yenned10409383_yenned
zinged174414623_zinged

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.420425454.8
2DLD Change Limit1340272616.03322215.6
3Display Results2612610.0932806.5
 (SQL Overall)1786912616.54627297.7
 
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.