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

130 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
averaged135621(None) 
average1158851average_
averages1249181averages
overaged13511671overaged
acerated113113982acerated
aerated85322372a_erated
avenged1245502ave_nged
averagely1642812averagely
averred11237592aver_red
averted112211612aver_ted
leveraged1463782leveraged
overage11514052overage_
overages12513832overages
overawed1579972overawed
verged114815162_ver_ged
aberrated1245873aberrated
abraded1138643a_braded
acerate92818913acerate_
acerbated1465553acerbated
acetated112010683acetated
acierated1238283acierated
acreage1037843acreage_
acreages1138373acreages
adverted1336103adver_ted
aerate64830553a_erate_
aerates74627493a_erates
aeried74221873a_er_ied
aerogel836523a_erogel
afeared1176833afe_ared
affrayed1842843affrayed
aggraded1244203aggraded
alerted82512223aler_ted
amerced1256523amer_ced
amperage1347743amperage_
amperages1447683amperages
aneared8512743ane_ared
arranged1036933a_rranged
arrased8149863a_rrased
arrayed11117153a_rrayed
asperated1239313asperated
assuaged1044383assuaged
asswaged1343333asswaged
aurated83817793a_urated
avenge1087553ave_nge_
avenger1135493ave_nger
avenges1157543ave_nges
averaging1446503averaging
averse95811183aver_se_
averter102410553aver_ter
aviated11310263av_iated
barraged1297693barraged
beraked144312433_beraked
berated104422133_berated
beverage1445143beverage_
beverages1595223beverages
caveated1439133cave_ated
caverned1436163caver_ned
cerated103922473_cerated
coverage1438733coverage_
coverages1538833coverages
deranged1137693_deranged
derated93623503_derated
diverged14256883diver_ged
emerged11158213emer_ged
enraged93511783_enraged
erased74816763__erased
everted112711853ever_ted
foraged124812283_foraged
garaged1039253_garaged
gheraoed1343353gheraoed
havered144011453haver__ed
herbaged1554533_herbaged
iterated91213823iterated
lacerated122210683lacerated
lateraled1047463lateraled
layerage1244963layerage_
layerages1345303layerages
leverage1285393leverage_
leverages1365663leverages
macerated142010523macerated
merged104214953_mer_ged
operated11512223operated
outraged102313103outraged
overacted1539633overacted
overalled1339073overalled
overarmed1538103overarmed
overate10620963overate_
overawe13511463overawe_
overawes14511183overawes
overbaked19127833overbaked
overbed132811853over_bed
overbred1459853overbred
overdared1439163overdared
overdyed16126513overdyed
overeager1348323overeager
overed102216623over__ed
overfed142510253over_fed
overfeed15299443overfeed
overhated16610443overhated
overladed1459223overladed
overrated13313083overrated
oversaved1638613oversaved
overseed122513353overseed
overtaxed20117243overtaxed
overurged1496673overurged
overused1249443overused
peerage1089803peerage_
peerages1189893peerages
preaged11612333pre_aged
presaged1238803presaged
raged74829453___raged
ravaged1236493rav__aged
savaged1236993sav__aged
serged84118773_ser_ged
teenaged10105133teenaged
unaverage1343553unaverage_
underaged121011233underaged
unerased9312783unerased
vealed103916323_ve_aled
vegged124910023_ve_gged
venged114011993_ve_nged
verge93419843_ver_ge_
verger104315703_ver_ger
verges104320183_ver_ges
versed104515523_ver_sed
visaged1235683_visaged
voyaged1533513_voyaged
waterage1248663waterage_
waterages1349383waterages
wavered142910433waver__ed

Search took 10 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.440406115.9
2DLD Change Limit1461621308.82616560.4
3Display Results1301300.0462826.1
 (SQL Overall)1786911309.31219189.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.