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

116 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
anthesis1131250(None) 
antheses11311471antheses
anthelia1149112anthelia
anthelix1845922anthelix
anthemia1349192anthemia
anthemic15410322anthemic
anthems12309422anthe_ms
antherid12611092antherid
antherids1368722antherids
anthers103715202anthe_rs
antithesis1345772antithesis
anuresis846962anuresis
aphesis12610512a_phesis
esthesis1148462esthesis
synthesis1546052synthesis
thesis94913732__thesis
actress948533actres_s
aesthesia1245943aesthesia
aesthesias1345693aesthesias
aetheric13410163aetheric
aethers103614943aethe_rs
agenesis938043agenesis
alphosis1347273alphosis
altheas1038233althe_as
anabasis1047373anabasis
analysis11128293analysis
anamnesis1144023anamnesis
anapests1046613anapests
anathemas1444883anathemas
anchusas1344763anchusas
anchusin1344773anchusin
anchusins1444543anchusins
ancress978613ancres_s
anemosis10148073anemosis
anesthesia1354433anesthesia
anesthesias1454033anesthesias
antbears1044963antbears
antefix1745053ant_efix
antes56334323ant_e__s
anthelices1546433anthelices
anthelion1246383anthelion
anthelions1345493anthelions
anthelixes2044883anthelixes
anthem113410343anthe__m
anthemed1446953anthemed
antheming1587293antheming
anthemion1445403anthemion
anther93715063anthe__r
antheral1149393antheral
anthills1146533anthills
anthodia1247803anthodia
anthoid11313313anth_oid
antihelix1944963antihelix
antis55033313ant___is
antisepsis1255123antisepsis
antitheses1345173antitheses
antlers74014743antle_rs
antres65021003antre__s
anureses837973anureses
apheses12610703a_pheses
apotheosis1553653apotheosis
aptness9268573aptnes_s
arthrosis1247553arthrosis
artless73712513artles_s
ascesis938373a_scesis
askesis1136123a_skesis
asthenia1167713asthenia
asthenias1277453asthenias
asthenic1378633asthenic
asthenics1486403asthenics
asthenies1278063asthenies
atheism1248523a_theism
atheisms1346923a_theisms
atheist10314063a_theist
atheists1138713a_theists
athetosis1244643a_thetosis
atresia7310223a_tresia
atresias839473a_tresias
atresic9310003a_tresic
attests7278813a_ttests
auxesis1445443a_uxesis
cantharis1447183cantharis
canthitis1445273canthitis
cathexis2045753cathexis
centesis1058143cent_esis
diathesis1345533diathesis
entasis73012573ent_asis
enthetic131110613enthetic
enthuses1138253enthuses
enuresis845493enuresis
epenthesis1593773epenthesis
estheses1137783estheses
esthesia1147503esthesia
esthesias1246733esthesias
nathless11127023nathles_s
nemesis937373_nemesis
noesis6311443_n_oesis
orthosis1148193orthosis
pantheism1645653pantheism
pantheisms1745073pantheisms
pantheist1449153pantheist
pantheists1546123pantheists
pantheons1446513pantheons
panthers13510783panthe_rs
parchesis16318213parchesis
parenthesis1654053parenthesis
phthisis1654443phthisis
prothesis1449433prothesis
syntheses1545683syntheses
synthesist1654983synthesist
theses96517973__theses
thesps11448263__thesps
tmesis8529793__tmesis
xanthein1845013xanthe_in
xantheins1944813xantheins
xanthenes1956353xanthenes

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.420425454.8
2DLD Change Limit1461621167.15620425.1
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.62223444.1
 
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.