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

44 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
resynthesis175304(None) 
resyntheses1752841resyntheses
resynthesize27152432resynthesize
resynthesizes28162262resynthesizes
synthesis1546052__synthesis
biosynthesis20152503biosynthesis
epenthesis1593763_epenthesis
esthesis1148463_es__thesis
parasynthesis2162283parasynthesis
resynthesized29152003resynthesized
syntheses1545683__syntheses
synthesist1654983__synthesist
aesthesia1245944aes__thesia
aesthesias1345694aes__thesias
anthesis11312504___anthesis
biosyntheses20162204biosyntheses
centesis1058144ce__nt_esis
chemosynthesis27162014chemosynthesis
epentheses1563804_epentheses
estheses1137784_es__theses
esthesia1147504_es__thesia
esthesias1246734_es__thesias
metathesis1544154me_tathesis
parasyntheses2162144parasyntheses
parenthesis1654054parenthesis
presentness1345664presentnes_s
prosthesis1546154pros__thesis
recentness1245464recentnes_s
relentless1043704relentles_s
resentments1346544resentments
resistless1043174resistles_s
restless82713164res__tles_s
restress82511774res__tres_s
resultless1041954resultles_s
resynthesizing3081314resynthesizing
syndesis1245734__syn_desis
syneresis1244844__syneresis
synesis1039164__syn__esis
synizesis2142354__synizesis
synthesists1753274__synthesists
synthesize2583924__synthesize
synthesizes2693814__synthesizes
synthetic1746624__synthetic
synthetics1844884__synthetics

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.420425454.8
2DLD Change Limit148819449.36015899.5
3Display Results44440.0162750.0
 (SQL Overall)178691449.79618241.2
 
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.