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

61 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
protamine13131091(None) 
prolamine131510561prolamine
protamin121210541protamin_
protamines14149801protamines
protamins131410771protamins
ergotamine1383422ergotamine
procaine12312272proca_ine
prolamin12139752prolamin_
prolamines14159362prolamines
prolamins13159702prolamins
promine112819442pro__mine
bromine112915243bro__mine
dopamine1346173_dopamine
ergotamines1473173ergotamines
etamine91313073__etamine
glutamine1243573glutamine
histamine1476903histamine
ketamine14157053_ketamine
petaline10314883p_etaline
plotline1037643plot_line
polyamine1647203polyamine
portaging1346843portaging
portative1449373portative
potamic13310853p_otami_c
potline91015233p_ot_line
praline93019743pr__aline
pretaping1439133pretaping
primine113214823pr__imine
probating14311193probating
probative1649173probative
procaines13311523proca_ines
profamily1943633profamily
profane122111863profa__ne
profaning1537293profaning
programing1646313programing
proline92321593pro__line
promines123018803pro__mines
promise113415843pro__mise
pronating12313763pronating
propane112716153propa__ne
propine113020213pro__pine
prorating12314283prorating
protasis102411973protasi_s
protatic12314743protati_c
proteide11239723prot_eide
protein92414733prot_ein_
proteins102114283prot_eins
protoxide1946823protoxide
provitamin1753303provitamin_
provitamins1853563provitamins
ptomaine1245533ptoma_ine
putamina1244543p_utamina
rhodamine1543553rhodamine
roaming103215793_ro_aming
rolamite1048743_rolamite
romaine9512123_roma_ine
rotating92614553_rotating
rotative11310343_rotative
trotline8310023trot_line
tryptamine1753123tryptamine
vitamine1347373_vitamine

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 Filter1786911486410.423422437.4
2DLD Change Limit148641616.79621871.8
3Display Results61610.0302033.3
 (SQL Overall)178691617.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.