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 “aggravates” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
aggravates155282(None) 
aggravate1443001aggravate_
aggravated1652461aggravated
aggregates1344122aggregates
margravates1752462margravates
aggrades1135863aggr__ades
aggravating1752413aggravating
aggravation1652663aggravation
aggravations1752433aggravations
aggregate1244203aggregate_
aggregated1443713aggregated
aguacates1244583a_guacates
gradates10510783__gradates
margravate1652513margravate_
margraviates1872023margraviates
abbreviates1851684abbreviates
abrogates12108974a_brogates
acerbates1347264acer_bates
acervate1336984acer_vate_
acrylates1446684a_crylates
activates1449684a_ctivates
aerates74627494a_er__ates
aestivates13107364aestivates
affricates1844614affricates
agametes1147294a_g_ametes
agates76121344a_g___ates
agaves104611514a_g_av__es
agemates111110024a_g_emates
aggadahs1462264agg_ada_hs
aggadas1055004agg_ada__s
aggradation1452994aggradation
aggradations1552704aggradations
aggrade1035644aggr__ade_
aggraded1244204aggr__aded
aggrandise1392854aggrandise
aggrandises1492764aggrandises
aggrandizes23122604aggrandizes
aggregately1751974aggregately
aggresses1146144aggr_esses
aggrieves14101904aggr_ieves
agitates9310884a_g_itates
agnates82813194a_g__nates
agrafes1137524a_gr__afes
agraffes1553044a_gra_ffes
aguacate1144974a_guacate_
aigrettes1046394aigr_ettes
airdates939724a_ir_dates
alginates10310124alg_inates
amadavats1551934amadavat_s
amirates101114794amir__ates
andradites1244774andradites
angulates10310864ang_ulates
approbates1645854approbates
arrogates10129424a_rrogates
aspartates1244674aspartates
avadavats1651514avadavat_s
cravats1237404__cravat_s
derivates13310094_derivates
enervates1248724ener_vates
engraves1237234engrav__es
excavates2144684_excavates
gavages1237684__g_avages
gradate9511234__gradate_
gradated1157434__gradated
graduates1147684__graduates
granites92116364__granites
grates75429894__gr__ates
gravamen1443934__gravamen
gravamens1542784__gravamens
graves104624004__grav__es
gravies11314094__grav_ies
gravitas12316014__gravitas
gravitates1444844__gravitates
gravities1338304__gravities
gravures1234904__gravures
gyrates113610264_gyr__ates
ingrates9514174ingr__ates
ingratiates1254414ingratiates
manganates1345954mang_anates
margraves1544834margrav__es
margraviate1752114margraviate_
margravines1752414margravines
migrates111112854migr__ates
paravanes1448304_paravanes
privates131812374__privates
pyruvates1743134_pyruvates
ravages1139404___ravages
reaggregates1593124reaggregates
regrates92618404regr__ates
savates10312954___savates
segregates1245334segregates
stravages1345844_stravages

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 Filter1786911614500.436409841.7
2DLD Change Limit161450929.26617423.9
3Display Results92920.0462000.0
 (SQL Overall)178691929.74818331.0
 
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.