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

178 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
averages124918(None) 
average1158851average_
averaged1356211averaged
overages12513831overages
acreages1138372acreages
aerates74627492a_erates
amperages1447682amperages
avenges1157542ave_nges
averagely1642812averagely
beverages1595222beverages
coverages1538832coverages
layerages1345302layerages
leverages1365662leverages
overage11514052overage_
overaged13511672overaged
overawes14511182overawes
peerages1189892peerages
verges104320182_ver_ges
waterages1349382waterages
abrades10312073a_brades
acerate92818913acerate_
acerated113113983acerated
acerbates1347263acerbates
acetates102013063acetates
acierates11310813acierates
acreage1037843acreage_
adages8412953a__dages
aerate64830553a_erate_
aerated85322373a_erated
aeries64737783a_er_ies
aerobes9311493a_erobes
aerogel836523a_erogel
aerogels945593a_erogels
aerugos834923a_erugos
agemates111110023agemates
aggrades1135863aggrades
agrafes1137523a_grafes
alienages1045973alienages
ambages1269623a_mbages
ameerates1149063ameerates
amerces1149853amer_ces
amesaces1246693amesaces
amirates101114793amirates
amperage1347743amperage_
anergies9310453anergies
anlages82414113a_nlages
apanages1137013apanages
aperies9423203aper_ies
apyrases1337243apyrases
arames84622573a__rames
arranges939413a_rranges
arrases71214543a_rrases
arrearages1143033arrearages
asperates11312553asperates
asperges11318093asper_ges
assuages936273assuages
asswages1255053asswages
auberges1146673auber_ges
avarices1337183avarices
avenge1087553ave_nge_
avenged1245503ave_nged
avenger1135493ave_nger
avengers1235583ave_ngers
avenses1049643ave_nses
avenues1057183ave_nues
averageness1555033averageness
averaging1446503averaging
averred11237593aver_red
avers85127313aver___s
averse95811183aver_se_
aversives1545913aversives
averted112211613aver_ted
averter102410553aver_ter
averters11249513averters
averts95715243aver__ts
avgases11106313av_gases
aviaries1139783aviaries
aviates10313063av_iates
barrages11711083barrages
berakes134815773_berakes
berates94126873_berates
beverage1445143beverage_
borages103917163_borages
brewages1436383brewages
cerates95428253_cerates
courages11311393courages
coverage1438733coverage_
deranges1039973_deranges
derates84028893_derates
diverges13258313diver_ges
emerges101310883emer_ges
enrages83114853_enrages
erases64425403__erases
forages114217283_forages
garages9314113_garages
gavages1237683gav__ages
gheraoes1244813gheraoes
herbages1437093_herbages
iterates81317823iterates
keelages1335743keelages
lacerates112413783lacerates
langrages11105903langrages
lavages1138603lav__ages
layerage1244963layerage_
leverage1285393leverage_
leveraged1463783leveraged
macerates132113573macerates
menages103615393_menages
merges94122493_mer_ges
metages102714973_metages
meterages1248183meterages
mirages102213533_mirages
moorages1139053moorages
operates10515413operates
outrages92215933outrages
overacts1339653overacts
overalls11410393overalls
overarms13258383overarms
overate10620963overate_
overawe13511463overawe_
overawed1579973overawed
overbakes18129133overbakes
overdares13310673overdares
overdoes121212543overdoes
overdyes15127473overdyes
overeager1348323overeager
overhates15311943overhates
overlades13510353overlades
overlies112417043overlies
overrates12414623overrates
oversales12313143oversales
oversaves15310183oversaves
oversees112415903oversees
overtakes16119823overtakes
overtaxes19118803overtaxes
overurges1387483overurges
overuses11312643overuses
peages94321853_pe_ages
peerage1089803peerage_
pelages10714613_pelages
presages11312203presages
rages64539443___rages
ravages1139403rav__ages
savages1139973sav__ages
seepages1137283seepages
serapes95218103_serapes
serfages1238233_serfages
serges74225973_ser_ges
sewages1139753_sewages
sewerages1345363sewerages
steerages1046493steerages
storages9311103storages
svarajes1843513svarajes
thenages12107483thenages
umbrages1336623umbrages
unaverage1343553unaverage_
underages11811083underages
valerates12310543valerates
vantages12119023vantages
veges94118873_ve__ges
venges104015153_ve_nges
ventages12119773_ventages
verbiages1544683_verbiages
verge93419843_ver_ge_
verged114815163_ver_ged
verger104315703_ver_ger
vergers114412633_ver_gers
verites103822263_verites
vermes115019143_ver_mes
verses94223763_ver_ses
verstes104014283_verstes
verves124617883_ver_ves
viragoes1245233_viragoes
viragos1146713_viragos
visages1138693_visages
vorlages1236033_vorlages
voyages1435703_voyages
waterage1248663waterage_

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.453394461.4
2DLD Change Limit1461621787.43619656.0
3Display Results1781780.0802225.0
 (SQL Overall)1786911787.96922423.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.