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

46 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
synapsis134514(None) 
asynapsis1452071asynapsis
synapses1344711synapses
synapsid1444261synapsid
synapsids1543221synapsids
synopsis1346651synopsis
asynapses1442022asynapses
synapse1234132synaps_e
synapsed1443132synapsed
synapsing1583482synapsing
synaptic1546282synaptic
syndesis1245732syndesis
synesis1039162syn_esis
synopses1346222synopses
apoapsis1244103apoapsis
apsis75718293___apsis
cyanosis1346273cyanosis
dynasts1155103dyna_sts
myasis114010473my_a_sis
myiasis1245493myia_sis
sepsis83011293s__epsis
shnapps1463343shnap_ps
shnaps1148083shnap__s
sinapism1245573sinapism
sinapisms1344793sinapisms
skepsis1344253s_kepsis
snappish1545243s_nappish
snaps74719563s_nap__s
stasis63116873s_ta_sis
steapsin1044713steapsin
steapsins1144633steapsins
stypsis1245243s_typsis
sycosis1238823sy_cosis
syllepsis1442473syllepsis
synaeresis1353043synaeresis
synagogs1343273synagogs
synanons1144633synanons
syndeses1245263syndeses
syneresis1244843syneresis
syngases1245073syngases
syngasses1343813syngasses
synizesis2142353synizesis
synopsize2353813synopsize
synopsizes2443303synopsizes
synoptic1546923synoptic
synthesis1546053synthesis

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.436409841.7
2DLD Change Limit146162466.86021306.4
3Display Results46460.0162875.0
 (SQL Overall)178691467.31224438.0
 
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.