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

113 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
accreted133633(None) 
accrete1137841accrete_
accretes1238111accretes
acceded1336102acc_eded
accented13107772accented
accepted15105382accepted
accosted1345512accosted
accredited1642662accredited
accrued1233822accr_ued
acerated113113982acerated
cacheted16148232cacheted
excreted1846152excreted
secreted1138632secreted
aborted10310423abor_ted
accede1138303acc_ede_
acceder1235363acc_eder
accedes1237723acc_edes
acceptee14105723acceptee
accepter14144933accepter
accessed1385403accessed
accorded14155353accorded
accounted1444823accounted
accouter1245363accouter
accoutred1443363accoutred
accredit1344843accredit
accreting1446333accreting
accretion1345933accretion
accretive1645093accretive
accrue1035823accr_ue_
accrues1135323accr_ues
accurate12410663accurate_
accursed1354633accursed
accused12368423acc_used
acerate92818913acerate_
acerbated1465553acerbated
acetated112010683acetated
achieved1743713achieved
acierated1238283acierated
acorned10238273acor_ned
acred87126353a_cr__ed
acted88521733a_c__ted
actuated1138743actuated
aculeated1247723aculeated
acylated1437873acylated
adverted1336103adverted
aerated85322373a_erated
agreed84712503a_gre_ed
airted74214503a_ir_ted
alerted82512223aler_ted
arcuated1138803arcuated
arete56031353a__rete_
aretes64425353a__retes
arrested939153a_rrested
ascribed1374693ascribed
asserted957903asserted
attrited947373attrited
aurated83817793a_urated
averted112211613aver_ted
baccated15148373bacc_ated
bucketed1736763bucketed
carpeted1338953carpeted
carted98631443_car_ted
casketed1534953casketed
cerated103922473_cerated
cocreated142710093cocreated
concreted1439413concreted
corseted11311473_corseted
coveted133011523_coveted
crated94827773__crated
created104323453__created
creed85727393__cre_ed
creped114115703__creped
crested103416533__crested
crewed125316563__crewed
curated104717583_curated
curetted1137173_curetted
curveted1435293_curveted
decreed112710253decre_ed
docketed16156583docketed
excrete1667163excrete_
excreter1766123excreter
excretes1787573excretes
faceted13509563fac_eted
ferreted1236333ferreted
garreted1057523garreted
jacketed22146533jacketed
lacerated122210673lacerated
lanceted1137073lanc_eted
macerated142010523macerated
occulted1344263occulted
packeted17148283packeted
picketed17167383picketed
picrated132110113picrated
pocketed17147143pocketed
racheted14149503racheted
racketed15169123racketed
ratcheted1554783ratcheted
recrated112918603recrated
recreated12412533recreated
rocketed15157793rocketed
sacheted14127833sacheted
scarted104816123scar_ted
screed95718933_scre_ed
screwed135710663_screwed
secrete9311073secrete_
secreter1038513secreter
secretes10410473secretes
socketed15177343socketed
ticketed15146643ticketed
turreted935373turreted
uncrated11416313uncrated
uncreated12312303uncreated
uncrewed1456763uncrewed

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621136.42022766.7
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.93625762.8
 
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.