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 “synopsis” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

63 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
synopsis134665(None) 
synapsis1345141synapsis
synopses1346221synopses
asynapsis1452072asynapsis
sycosis1238822syco_sis
synapses1344712synapses
synapsid1444262synapsid
synapsids1543222synapsids
syndesis1245732syndesis
synesis1039162syn_esis
synopsize2353812synopsize
synopsizes2443302synopsizes
synoptic1546922synoptic
anopsia9258443_anopsia
anopsias10337983_anopsias
asynapses1442023asynapses
cyanosis1346273cyano_sis
enosis63816423_eno_sis
gnosis75711213_gno_sis
hypnosis1646533hypno_sis
kenosis11369003keno_sis
mycosis1437763myco_sis
myosis114012563my_o_sis
noesis6311443__noesis
pycnosis1554733pycno_sis
pyknosis1753643pykno_sis
pyosis114012123py_o_sis
pyrosis12411653pyro_sis
senopia949233senop_ia
senopias1048823senopias
sepsis83011293s__epsis
sinopia947743sinop_ia
sinopias1047873sinopias
sinopie948783sinop_ie
skepsis1344253s_kepsis
sorosis72611973soro_sis
stenosis847993steno_sis
stypsis1245243s_typsis
sycoses1249133syco_ses
syllepsis1442473syllepsis
symposia1545783symposia
synapse1234133synaps_e
synapsed1443133synapsed
synapsing1583483synapsing
synaptic1546283synaptic
syncopes1545763syncop_es
syncopic1745633syncop_ic
syndeses1245263syndeses
syneresis1244843syneresis
syngases1245073syngases
synizesis2142353synizesis
synodic1347363syno_dic
synods1077953syno__ds
synonyms1643893synonyms
synopsized2552423synopsized
synostosis1353953synostosis
synovia1345533syno_via
synovias1445303synovias
synovitis1544653synovitis
synthesis1546053synthesis
sysops1136013sysop__s
zygosis20405953zygo_sis
zymosis21487493zymo_sis

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.406440125.6
2DLD Change Limit146162636.81321453.4
3Display Results63630.0302100.0
 (SQL Overall)178691637.24924650.4
 
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.