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

98 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
cantharides175403(None) 
cantharidin17102412cantharidin
cantharidins18122212cantharidins
cantharis1447182canthari__s
lanthanides1553052lanthanides
antherids1368723_antherid_s
canaries10318943can__ari_es
cantabiles1445763cant_abiles
cantatrices1553443cantatrices
canthitises1643553canthitises
catharses1446413ca_thar_ses
contraries12711933contrari_es
lanthanide1453043lanthanide_
saccharides1953753saccharides
acetamides1543604acet_amides
actuaries1147564_actuari_es
anchorites1547754_anchorites
angaries9314394_an_gari_es
anhydrides1872024_anhydrides
antacids1148334_ant_acid_s
anthelices1546434_anthelices
anthelixes2044884_anthelixes
antherid12611094_antherid__
antheridia1453924_antheridia
anthraces1448894_anth_races
anthracites1674954_anthracites
anthuriums1553274_anthuriums
antiarins9413894_antiari_ns
anticaries12412474_anticari_es
antitrades1146524_antitrades
ascarides12346954_a_scarides
authorises1347584_authorises
authorizes2247004_authorizes
bastardies1365144bast_ardies
calamaries1446874calamari_es
calvaries1449804ca_lvari_es
canalises11515494can__alises
canalizes201113784can__alizes
canards10311204can__ar_d_s
canewares1447364canewar__es
cannabises1444434can_nabises
canneries11313084can_neri_es
cannonries1244094cannonri_es
canonries1148414can_onri_es
cantabile1346894cant_abile_
cantatrice1463464cantatrice_
canthitis1445274canth__itis
cantraips13255274cantra_i_ps
cantrips12318934cant__ri_ps
carbamides1745134ca_rbamides
carthorses1546364carthor_ses
cartridges1472834cart__ridges
cartularies1345374cartulari_es
caryatides1644494ca_ryatides
catamites1349364ca_t_amites
catenaries1248664catenari_es
catharsis1444484ca_thar_sis
cathartics1743084ca_thartics
cathodes1439394ca_th__odes
catteries11815524ca_tteri_es
cauteries11615394caut_eri_es
cauterizes2197994caut_erizes
centares102913894cent_ar__es
centauries1245534centauri_es
centenaries1346484centenari_es
centiares1167654centiar__es
centralises1349294centralises
centralizes2249424centralizes
centuries11311334cent_uri_es
chantries14310294chant__ri_es
charades141310854c___harades
clitorides1344444clit_orides
contrarians1346354contrarians
contrariness1455484contrariness
contrarious1354734contrarious
contrives14311704cont__rives
costmaries1446914costmari_es
cyanamides1842954cyan__amides
dataries9314034da_t_ari_es
earthrises1346824earth_rises
fantasies1298854fant_asi_es
fantasises1395884fant_asises
fantasizes2295464fant_asizes
gantries91413784gant__ri_es
janisaries1744784janisari_es
janizaries2643504janizari_es
katharses1643874ka_thar_ses
laniaries9411214lan_iari_es
pantries101817394pant__ri_es
saccharide1853634saccharide_
sanctuaries1353354sanctuari_es
sanitaries1049914sanitari_es
tantalises101010104tant_alises
tantalites1099284tant_alites
tantalizes19109944tant_alizes
xanthates1945654xantha__tes
xanthines1966724xanth__ines
zoantharians2481734zoantharians

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 Filter1786911488190.436409841.7
2DLD Change Limit148819989.31315979.7
3Display Results98980.0631555.6
 (SQL Overall)178691989.81218211.5
 
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.