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

190 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
average115885(None) 
averaged1356211averaged
averages1249181averages
overage11514051overage
acerate92818912acerate
acreage1037832acreage
aerate64830552a_erate
amperage1347742amperage
avenge1087552ave_nge
averagely1642812averagely
averse95811182aver_se
beverage1445142beverage
coverage1438732coverage
layerage1244962layerage
leverage1285392leverage
overaged13511672overaged
overages12513832overages
overate10620962overate
overawe13511462overawe
peerage1089802peerage
unaverage1343552unaverage
verge93419832_ver_ge
waterage1248662waterage
abrade9313053a_brade
acerated113113983acerated
acerbate1247533acerbate
acerose9310893acerose
acervate1336983acervate
acetate92514753acetate
acierate10311813acierate
acreages1138363acreages
adage7414053a__dage
adverse1145953adver_se
aerated85322373a_erated
aerates74627493a_erates
aerie54634603a_er_ie
aerobe8412403a_erobe
aerogel836523a_erogel
aerugo735803a_erugo
agemate101210583agemate
aggrade1035643aggrade
agorae7511203agora_e
agrafe1038093a_grafe
alienage945583alienage
ambage11510603a_mbage
amebae1049633ameba_e
ameerate1039633ameerate
amerce10310513amer_ce
amesace1147733amesace
amirate91115953amirate
amperages1447683amperages
anergy10156863aner_gy
anlage72514223a_nlage
apanage1036803apanage
apyrase1236363apyrase
arame75026623a__rame
areae55229743are_a_e
arrange838683a_rrange
arrearage1042863arrearage
asperate10312373asperate
assuage835683assuage
asswage1144673asswage
auberge1045633auber_ge
aurae54128113a_ura_e
aurate64426473a_urate
aureate72515283aureate
avarice1238033avarice
avellane1146263avellane
avenged1245503ave_nged
avenger1135493ave_nger
avenges1157543ave_nges
avenue957953ave_nue
aver75931883aver___
averaging1446503averaging
averrable14105413averrable
averred11237593averred
avers85127313aver__s
aversive1447443aversive
avert86029493aver__t
avertable14117343avertable
averted112211613averted
averter102410553averter
averts95715243aver_ts
aviate9315203av_iate
barrage10710843barrage
berake124216083_berake
berate84729023_berate
beverages1595223beverages
borage93917013_borage
brewage1347183brewage
camerae11312063camera_e
cerate84829463_cerate
courage10310993courage
coverages1538833coverages
degage92711383_degage
derange939813_derange
derate74531233_derate
diverge12347643diver_ge
emerge91510463emer_ge
enrage72715073_enrage
erase54925493__erase
forage104617003_forage
garage8314513_garage
gavage1137193gav__age
herbage1337003_herbage
interage9314483interage
iterate71119113iterate
keelage1236183keelage
lacerate102214703lacerate
langrage10106033langrage
lavage1038263lav__age
layerages1345303layerages
leveraged1463783leveraged
leverages1365663leverages
macerate122314073macerate
menage93216543_menage
merge84523683_mer_ge
metage93114453_metage
meterage1147933meterage
mirage92313653_mirage
moorage1038743moorage
operate9615733operate
outrage82616893outrage
overable13513573overable
overact12315043overact
overall10411083overall
overapt12312653overapt
overarm12239793overarm
overawed1579973overawed
overawes14511183overawes
overbake17129803overbake
overcame151310693overcame
overdare12311183overdare
overdue11138953overdue
overdye14126923overdye
overeager1348323overeager
overhate14312793overhate
overlade12611553overlade
overlarge1346823overlarge
overlate11716283overlate
overlie102615013overlie
overrate11615693overrate
oversale11313873oversale
oversave14310493oversave
oversee102717603oversee
overtake151210143overtake
overtame131510523overtame
overurge1277103overurge
overuse10310923overuse
peage84723563_pe_age
peerages1189893peerages
pelage9515363_pelage
prerace11414123prerace
presage10312293presage
rage55742353___rage
ravage1039303rav__age
savage10410173sav__age
seepage1037543seepage
serape84818413_serape
serfage1138403_serfage
serge64727463_ser_ge
sewage10310733_sewage
sewerage1245513sewerage
steerage946833steerage
storage8310473storage
subaverage1651903subaverage
teenage8108053teenage
thenage11107843thenage
umbrage1236723umbrage
underage101012273underage
valerate11311473valerate
vantage11109893vantage
velate93720143_velate
venae85920983_vena_e
venge95117983_ve_nge
ventage11109623_ventage
vera76828843_vera__
verbiage1444553_verbiage
verged114815153_ver_ged
verger104315693_ver_ger
verges104320173_ver_ges
verite94323443_verite
verse84723583_ver_se
verste94515633_verste
verve115417723_ver_ve
virago1046643_virago
visage1049083_visage
vorlage1136403_vorlage
voyage1335473_voyage
waterages1349383waterages

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271906.86019537.5
3Display Results1901900.0633015.9
 (SQL Overall)1786911907.06325299.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.