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 “authored” 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
authored123826(None) 
anchored1438602anchored
author939762author__
authoress1245172authoress
authorised1444512authorised
authorized2345222authorized
authors10311852author_s
autoed7712822aut_o_ed
coauthored1642442coauthored
tutored837552tut_ored
wuthered15157432wuthered
abhorred1443503a_bhorred
adhered1239233a_dhered
adored84714243a__dored
altered83215753alt_ered
althorn1047763althor_n
althorns1146733althorns
anchoret13412463anchoret
anthemed1446953anthemed
antherid12611093antherid
anthoid11313313antho_id
antired82316193ant_ired
antlered938263antlered
arbored103811603a_rbored
armored102610473a_rmored
ashore9414613a_shore_
athodyd1542693a_thodyd
atoned75417543a_t_oned
attired8238913a_ttired
attorned955363a_ttorned
auctioned1244953auctioned
augured987193au_gured
aunthood1254723auntho_od
aureoled945743aureoled
ausformed1542323ausformed
authorial1247083authorial
authoring1348583authoring
authorise1248023authorise
authorises1347583authorises
authority1545693authority
authorize2146903authorize
authorizer2244543authorizer
authorizes2247003authorizes
automen939653aut_omen
autopen947123aut_open
bethorned1544443bethorned
bothered142110393bothered
butchered1744583butchered
buttered112712633buttered
buttoned1137503buttoned
cautioned1245363cautioned
chored125321883__chored
dithered13189293dithered
euchred13106163euch_red
factored1436233fact_ored
fathered151510433fathered
fathomed1744733fathomed
furthered1644483furthered
futhorc1544313futhor_c
futhorcs1643543futhorcs
futhork1745103futhor_k
futhorks1844603futhorks
gathered13149383gathered
guttered10259173guttered
humored1336723hu_mored
lathered121512333lathered
lithoed1137833litho_ed
mothered142310103mothered
motored1039933mot_ored
murthered1544483murthered
muttered112610803muttered
outboxed1836873outboxed
outbred10311263out_bred
outdared102711513outdared
outfired1238083outfired
outfoxed1936013outfoxed
outhomer1348133outhomer
outhomered1643683outhomered
outhowled1645103outhowled
outhumored1642303outhumored
outloved12248583outloved
outmoded12207703outmoded
outmoved14247283outmoved
outpoured1246013outpoured
outroared10158123outroared
outrowed1239443outrowed
outscored12207073outscored
outsnored10175983outsnored
outsoared10157593outsoared
outvoted1237273outvoted
outwore101912693outwore_
outworked1745573outworked
pastored1139973past_ored
pothered142311043pothered
potholed1448393potholed
puttered112611153puttered
rumored1046643ru_mored
shored105723653__shored
stored75524213_st_ored
succored13135173succored
sutured8310373sut_ured
tethered1238493tethered
tholed105113873__tholed
thorned11479403__thorned
thoued10429003__thoued
tutoyed1133943tut_oyed
unhired112512153_unhired
unhoped13249353_unhoped
unhorsed1238833_unhorsed
ushered1139153_ushered
uttered82712443_uttered
whored135512123__whored
withered15169433withered

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 Limit1461621137.29620033.2
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.76523012.4
 
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.