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

88 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
synopses134622(None) 
synapses1344711synapses
synopsis1346651synopsis
asynapses1442022asynapses
sycoses1249132syco_ses
synapse1234132synapse_
synapsed1443132synapsed
synapsis1345142synapsis
syncopes1545762syncop_es
syndeses1245262syndeses
syngases1245072syngases
synopsizes2443302synopsizes
asynapsis1452073asynapsis
canopies12311853canopies
copses104922473__copses
cyanoses1337423cyano_ses
dynodes1235453dyno_des
genoises939253genoises
gnoses76515163_gno_ses
hydropses1846033hydropses
hypnoses1646633hypno_ses
mycoses1437733myco_ses
myopes13419963my_op_es
myopies14309723my_opies
myoses114013843my_o_ses
noises65021853__noises
nooses65623653__nooses
noses55435643__no_ses
nouses64627163__nouses
pycnoses1554973pycno_ses
pyknoses1783573pykno_ses
pyoses114314303py_o_ses
pyropes142210193pyrop_es
saroses73619333saro_ses
scopes104719593s_cop_es
scouses93313243s_couses
senopias1048823senopias
senores73218113seno_res
senses63923943sen__ses
sepses84515883s__epses
shoppes143411403s_hoppes
shynesses1535313shynesses
sinopias1047873sinopias
sinopie948783sinopie_
sinuses73011593sin_uses
slopes84820453s_lop_es
slynesses1235863slynesses
snipes83917393s_nip_es
snoozes16289783s_noozes
snores64324323s_no_res
soroses73117493soro_ses
souses64229243s__ouses
spouses92912813s_pouses
stenoses8310443steno_ses
stopes84525893s_top_es
strophes13310603strophes
sunrises8310693sunrises
supposes1238203supposes
syboes1139343sybo__es
sycosis1238823syco_sis
syllepses1442843syllepses
synapsid1444263synapsid
synapsids1543223synapsids
syncopates1754183syncopates
syncope1445383syncop_e_
syndesis1245733syndesis
synereses1245313synereses
synesis1039163syn_esis
synesises1245613synesises
syngasses1343813syngasses
synizeses2162443synizeses
synods1077953syno__ds
synonymes1743603synonymes
synonyms1643893synonyms
synopsize2353813synopsize
synopsized2552423synopsized
synoptic1546923synoptic
synostoses1344533synostoses
synovias1445303synovias
syntaxes1843633syntaxes
syntheses1545683syntheses
syntonies1248153syntonies
sysops1136013sysop__s
woopses1237883_woopses
xenopuses1843373xenopuses
xyloses1746843xylo_ses
zygoses20436783zygo_ses
zymoses21608703zymo_ses

Search took 7 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.440406115.9
2DLD Change Limit146162886.37322934.6
3Display Results88880.0461913.0
 (SQL Overall)178691886.85926052.0
 
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.