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

87 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
tyrosine114704(None) 
tyrosines1246861tyrosines
cytosine1346872cytosine
kerosine1238142kerosine
pyronine1349512pyronine
thyroxine2243912thyroxine
tropine93116652t_ropine
tylosin1046902tylosin_
tylosins1145722tylosins
tyramine1347302tyramine
tyrosinase1352442tyrosinase
arcsine94512393_arcsine
arsine64021043_ar_sine
atropine10410113atropine
bromine112915243_bromine
cosine83823513__cosine
crocine11314153_crocine
cytokine1745023cytokine
cytosines1446223cytosines
eosine64519413__eosine
erosive1039193_erosive
gyrose105310253gyros__e
heroine103517483hero_ine
hyoscine1644183hy_oscine
inosine7314283_inosine
jarosite1548383jarosite
kerosene1254823kerosene
kerosines1357103kerosines
lysine94210553ly__sine
myosin113410763my_osin_
myosins12278963my_osins
nigrosine1044743nigrosine
proline92321593_proline
promine112819443_promine
propine113020213_propine
prosing103319383_prosing
pyridine1447743pyridine
pyrolize2248133pyrolize
pyrone112714473pyro__ne
pyronines1458323pyronines
pyrosis12411653pyrosi_s
pyrosises1457583pyrosises
pyroxene2045083pyroxene
rosin55325313__rosin_
rosined84911903__rosined
rosing73925593__rosing
rosins64521863__rosins
rosiny94414533__rosiny
rusine63916593__rusine
serotine8313573serotine
taborine102510683taborine
teosinte845543t_eosinte
terrine72517573ter_rine
thionine1187923thionine
threonine1245103threonine
throne98517603thro__ne
throning1238863throning
throstle1175703throstle
throwing1536723throwing
thymosin1644493thymosin_
thymosins1744203thymosins
thyroxin2144183thyroxin_
thyroxines2343703thyroxines
thyroxins2243643thyroxins
torose64317693toros__e
torosity1147243torosity
toxine133114123t__oxine
trine54734603t_r__ine
troking123514103t_roking
trone55131863t_ro__ne
tropin83316753t_ropin_
tropines102214923t_ropines
tropins93116313t_ropins
trotline8310023t_rotline
trowing113413703t_rowing
trypsin1245113trypsin_
trypsins1344903trypsins
turbine9310303tur_bine
turdine8310283tur_dine
tyramines1447213tyramines
tyring104613023tyr__ing
tyrocidine1652803tyrocidine
tyronic1239313tyroni_c
tyros85118593tyros___
tyrosinases1452723tyrosinases
ursine64114123_ur_sine
versine102515173ver_sine

Search took 9 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.420425454.8
2DLD Change Limit146162877.67319048.9
3Display Results87870.0302900.0
 (SQL Overall)178691878.12321998.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.