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

411 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
avenses104964(None) 
avenges1157541avenges
avenues1057181avenues
adenoses947902adenoses
agenes74720252agen_es
ageneses939302ageneses
akenes104817342aken_es
arenes64928392aren_es
asepses946362asepses
avenge1087552avenge_
avenged1245502avenged
avenger1135492avenger
avengers1235582avengers
avens86419332aven__s
avenue957952avenue_
averse95811182averse_
avgases11106312avgases
avulses1035432avulses
censes83721802_censes
flenses1039472flenses
lenses64620892_lenses
menses84222452_menses
senses63923942_senses
spenses92913572spenses
tenses64722552_tenses
venges104015152_venges
venues95115202_venues
venuses103111412_venuses
verses94223762_verses
abases85720773a_bases
abbesses1235333abbesses
abeles84719393abe_les
abioses9311493abioses
absences1247673absences
abuses85119103a_buses
abysses1234863abysses
accesses1287493accesses
accuses114112193accuses
achenes12313493achen_es
acnes75922623a_cn_es
adenines9310193adenines
adenosis946343adenosis
adenyls1143923adenyls
adonises92611433adonises
advances1445613advances
advents11309473adven_ts
adverse1145953adverse_
advises11138973advises
aedes64625153a_e_des
aegises8311373aegises
aeneus61111143a_eneus
aeries64737783a_eries
agedness1036683agedness
ageisms1056603ageisms
ageists848493ageists
ageless8310343ageless
agencies1138743agencies
agendas936933agendas
agene65621583agen_e_
agenesis938043agenesis
agenizes18269743agenizes
agented939423agented
agents74816293agen_ts
agones75719863agon_es
agonies83016623agonies
agonises92613163agonises
akees96119243ake__es
akene95818663aken_e_
aldoses8311203aldoses
aliases7914493aliases
alienees8118653alienees
alines65735223alin_es
aliveness1238223aliveness
alkenes114212753alken_es
amasses93912853amasses
amended11328313amended
amender10349613amender
amenders11288353amenders
amends94713283amen_ds
amens75624843amen__s
aments85219803amen_ts
amerces1149853amerces
amines84727983amin_es
amuses85117943a_muses
anankes1138763anankes
aneles64626293ane_les
anemoses10159433anemoses
anenst63514983anens_t
anes45255933a__n_es
anises64826693a_nises
ankuses1148203ankuses
anlases72514903anlases
annexes1437203annexes
antes56334323a__ntes
anuses66218773a_nuses
aperies9423203aperies
apexes1539133ape_xes
apheses12610703apheses
appeases1238663appeases
apposes11511473apposes
apses76823913a__pses
aptness9268573aptness
arcuses94814693arcuses
arenas65021993aren_as
arene55329413aren_e_
arenites8917103arenites
arenose7311373arenose_
arenous7314183arenous
areoles71016953areoles
aretes64425353are_tes
arguses84711743arguses
arises65233803a_rises
arkoses113910833arkoses
arouses74921293arouses
arrases71214543arrases
arrises71617583arrises
arses55733873a__rses
asceses938623asceses
asepsis985903asepsis
askeses1136463askeses
asperses104111673asperses
aspises9611643aspises
asses55629283a__sses
assesses737383assesses
atlases72410643atlases
atones65225773aton_es
atonies75320953atonies
auxeses1435623auxeses
averages1249183averages
averred11237593averred
avers85127313ave__rs
aversely1444853aversely
aversives1545913aversives
averted112211613averted
averter102410553averter
averters11249513averters
averts95715243ave_rts
aves76142603av___es
avgasses1284193avgasses
aviates10313063aviates
avidness1246113avidness
avisos95410483av_isos
avoset9315673av_oset
avosets1036663av_osets
avulse935843avulse_
avulsed1133833avulsed
aweless1038723aweless
axises134413993a_xises
axones134614513axon_es
azines155517073azin_es
bareness10912813bareness
baseness10910943baseness
benes75536233_ben_es
bennes86019013_bennes
beses75830723_be_ses
blendes104713683blendes
blesses93812393blesses
braveness14237763braveness
cadences1338473cadences
caresses10314063caresses
caseases10410473caseases
caseoses1039293caseoses
cayennes1345013cayennes
ceases84427073_ceases
cense75121403_cense_
censed94016323_censed
censer84516583_censer
censers94313903_censers
census84310303_census
cesses84221363_cesses
cheeses123613103cheeses
chesses124112633chesses
cleanses10358143cleanses
creases94020963creases
creeses93914623creeses
cresses94219813cresses
cyeses11510123cye_ses
davened124610073daven_ed
davens104612913daven__s
defenses1237913defenses
denes65639723_den_es
denies74729643_denies
dense65923503_dense_
denser74115193_denser
densest83112473_densest
devises114116763devises
dienes75719903dien_es
dieses75218693die_ses
dresses83716173dresses
duendes938193duendes
dueness82310123dueness
eases56041613__eases
elevenses1244333elevenses
emeses86114963eme_ses
ensues63313813__ensues
erses55826803__erses
eses45336103__e_ses
esnes54817363__esnes
esses56422973__esses
evened101010313even_ed
evener91010623even_er
eveners10109503eveners
evenest10312103evenest
evenness1135543evenness
evens84817103even__s
events94814073even_ts
evinces1237803evinces
evulses1035043evulses
expenses17138373expenses
faiences1337043faiences
favuses1336183fav_uses
feases95422923_feases
fences114617113_fences
fesses94820253_fesses
flense938903flense_
flensed1136613flensed
flenser1036783flenser
flensers1135463flensers
gameness112810693gameness
genes65133093_gen_es
geneses82613523_geneses
genies75324943_genies
genres75515623_genres
gentes75324163_gentes
genuses83510883_genuses
graveness13288383graveness
greases84816713greases
guesses8169373guesses
haleness11312623haleness
hanses95022633_hanses
havened14429243haven_ed
havens124514043haven__s
henges104516463_henges
ileuses738673ileuses
incenses102411003incenses
inverses112410983inverses
jesses135215953_jesses
joneses1438963joneses
kavasses1544303kavasses
kentes105118653_kentes
kineses113111253kineses
kvases13467103kv_ases
kvasses14365503kvasses
lameness102612673lameness
lateness82614073lateness
lavender1235143lavender
lavenders1334753lavenders
leases65428113_leases
lenes54738523_len_es
lense54523433_lense_
lensed74015473_lensed
leses54930813_le_ses
licenses10118923licenses
liveness112411393liveness
loesses7310033loesses
maleness10312313maleness
manses84225513_manses
mavens114312973maven__s
mavises122812993mav_ises
mensas85115863_mensas
mense75025633_mense_
mensed93916543_mensed
menshes12310453_menshes
mesnes85216213_mesnes
messes84924343_messes
naiveness1277493naiveness
navettes1136613navettes
nenes55329673_nen_es
nesses64718323_nesses
obverses1335803obverses
offenses1443833offenses
oneness7512143oneness
ovens86217453oven__s
oversea102412113oversea
overseas112612423overseas
oversee102717603oversee
oversees112415903oversees
overset102821473overset
oversets113114173oversets
oversew132810833oversew
oversews14289423oversews
overuses11312643overuses
ovines94614343ovin_es
oyesses1037333oyesses
paleness10312983paleness
pareses94718883pare_ses
parvenues1444643parvenues
pavanes123612653pavan_es
pavises125315493pav_ises
pavisses13397103pavisses
peases85229473_peases
peises84125043_peises
penes75839223_pen_es
penises9318193_penises
pensee8417313_pensee
pensees9311203_pensees
perses85428063_perses
pleases94515483pleases
presses93523153presses
rareness81112853rareness
ravened115012283raven_ed
ravener104110743raven_er
raveners11309133raveners
ravenous1146793ravenous
ravens93916883raven__s
ravines104220233ravin_es
rentes65431193_rentes
reuses66025523_reuses
revenges1238983revenges
revenues1138663revenues
reverses112513513reverses
revises104220533revises
rinses64720383_rinses
safeness11239633safeness
sageness92111983sageness
sameness102712683sameness
saneness82313723saneness
savines104417633savin_es
scavenges1542903scavenges
scenes84520353scen_es
seises64026713_seises
sense55526823_sense_
sensed73918163_sensed
sensei64712593_sensei
senseis73310643_senseis
sepses84515883_sepses
skenes104616633sken_es
speises93813933speises
spences113413923spences
spense83912433spense_
stenoses8310443stenoses
suaveness1247703suaveness
tameness102411253tameness
teases65426273_teases
tense55225843_tense_
tensed74817833_tensed
tenser64919433_tenser
tensest72713313_tensest
tenues63816443_tenues
theses96517973the_ses
tmeses85712243tme_ses
traverses1246343traverses
tresses73719543tresses
tsetses785453tsetses
uneases73316263uneases
ureases74416723ureases
valences1388513valences
valises103516263valises
valses94514613_valses
vamoses1239153vamoses
vanes85130973_van_es
varuses10310623varuses
vases84626263_v_ases
vees75439433_ve__es
veges94118873_ve_ges
vegies104314273_vegies
venae85920983_venae_
vended114416353_vended
vendee105617263_vendee
vendees114011453_vendees
vender103418423_vender
venders113717003_venders
vends95520893_ven_ds
vendues11318623_vendues
veneer94511693_veneer
veneers103710293_veneers
venenes102712133_venenes
venge95117993_venge_
venged114011993_venged
venines103516613_venines
venins93816703_venins
venires103012453_venires
venoms114211213_venoms
venose9310843_venose_
venous93713193_venous
vented104617923_vented
venter94218723_venter
venters103717733_venters
vents86125933_ven_ts
venue84918213_venue_
venules104011483_venules
venus84918903_ven_us
verges104320183_verges
vermes115019143_vermes
verse84723583_verse_
versed104515513_versed
verser94516963_verser
versers103813523_versers
verset94327323_verset
versets103913103_versets
versos93812803_versos
verstes104014283_verstes
versts93914733_versts
versus94211143_versus
verves124617883_verves
vessel937953_vessel
vessels1035933_vessels
vests85325983_ve_sts
vetoes92914083_vetoes
vexes155719123_ve_xes
vines85137643_vin_es
vises84427773_v_ises
waeness102512783waeness
waveless1437483waveless
waviness1437723waviness
weenies102915093weenies
wienies102213683wienies
woeness1020211543woeness
yentes95517603_yentes
yeses85119323_ye_ses
yesses93615813_yesses

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.403443402.0
2DLD Change Limit1340274115.87622809.2
3Display Results4114110.1562634.6
 (SQL Overall)1786914116.43527768.6
 
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.