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

104 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
accepted1510540(None) 
accented13107791accented
acceptee14105741acceptee
accepter14144951accepter
acceded1336112acce_ded
accept123210632accept__
acceptedly2052182acceptedly
acceptees15113712acceptees
accepters15114622accepters
acceptor14114912acceptor
accepts13356362accept_s
accessed1385412accessed
accosted1345532accosted
accreted1336342accreted
excepted2055242excepted
incepted13177792incepted
reaccepted1743332reaccepted
unaccepted1743392unaccepted
abetted1058323a_betted
absented1156613absented
accede1138303acce_de_
acceder1235363acce_der
accedes1237723acce_des
accent105116263accent__
accentor12106133accentor
accents113511233accent_s
acceptant1545033acceptant
accepting1695813accepting
acceptive1845083acceptive
acceptors15114803acceptors
accesses1287493accesses
accipiter15133743accipiter
accorded14155363accorded
accounted1444823accounted
accouter1245363accouter
accoutred1443363accoutred
accredited1642663accredited
accrete1137843accrete_
accretes1238113accretes
accrued1233823acc_rued
accursed1354633accursed
accused12368423acc_used
acerated113113993acerated
acetated112010683acetated
acierated1238293acierated
acted88521733a_c__ted
actuated1138743actuated
aculeated1247723aculeated
acylated1437873acylated
adapted1135843a_dapted
adepter1036113a_depter
adopted1136253a_dopted
advected1534533advected
adverted1336103adverted
affected1744793affected
agented939423a_gented
alerted82512223a_lerted
arcuated1138803arcuated
arrested939163arrested
ascended1246513ascended
assented957513assented
asserted957903asserted
attempted1442563attempted
attested936303attested
averted112211613a_verted
baccated15148373bacc_ated
cacheted16148233cacheted
carpeted1338953carpeted
caseated11310713caseated
caveated1439133caveated
cheated134416343_cheated
chested133811673_chested
cleated103417843_cleated
clefted13326753_clefted
cleped115114113_clep_ed
coapted123911503_coapted
coempted1535333_coempted
compted143813523_compted
coopted123710773_coopted
created104323453_created
creped114115713_crep_ed
crested103416543_crested
discepted1547523discepted
excerpted2153873excerpted
faceted13509563face_ted
facetted1445743facetted
incented112412543incented
jacketed22146533jacke_ted
lanceted1137073lance_ted
occulted1344263occulted
occupied1542953occupied
packeted17148283packe_ted
racheted14149503rache_ted
racketed15169123racke_ted
reaccented1544893reaccented
receipted1445343receipted
sacheted14127833sache_ted
scented102811883_scented
scepter1138363_scepter
sceptred1343653_sceptred
scripted13117563scripted
sculpted1354883sculpted
unaccented1544283unaccented
ycleped1543393yclep_ed

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.423422437.4
2DLD Change Limit1461621047.03320782.3
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.48623870.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.