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

69 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
tylosin104690(None) 
tylosins1145721tylosins
myosin113410762my_osin
thymosin1644492thymosin
tyrosine1147042tyrosine
acyloin1247463acylo_in
aloin55227423_alo_in
amylopsin1652803amylopsin
celosia939463celosia
chlorin123113003chlorin
chymosin1845013chymosin
closing103114843_closing
cycasin1445903cycasin
cyclosis1547473cyclosis
cytosine1346873cytosine
eclosion1046903eclosion
eloin55923203_elo_in
eosin55220923__eosin
florin9312653_florin
globin9309723_globin
login66025003__login
loin46838723__lo_in
losing74022873__losing
lysin84512783__lysin
mycosis1437763mycosis
myosins12278963my_osins
myosis114012563my_osis
nylon82910513nylo__n
plosion939113_plosion
pocosin1169643pocosin
pylon103614003pylo__n
pylori1147163pylori_
pyloric1438063pyloric
pyosis114012123py_osis
pyrosis12411653pyrosis
rosin55325313__rosin
stylising1345593stylising
styloid1137553stylo_id
sycosis1238823sycosis
sylvin12247303syl_vin
taborin92210453taborin
talon55824113talo__n
telesis7310793telesis
teloi54217383telo_i_
telomic1147603telomic
telos55424523telos__
telson6310293tel_son
thionin1048673thionin
thymosins1744203thymosins
thyroxin2144183thyroxin
tocsin8311003t_ocsin
tolidin839243tolidin
toxin124716713t__oxin
tropin83316753t_ropin
trypsin1245113trypsin
tycoon1136023tyco_on
tyin76424003ty___in
typos106015813typos__
tyronic1239313tyronic
tyros85118593tyros__
tyrosines1246863tyrosines
xylidin1844333xylidin
xyloid1738193xylo_id
xylose1636763xylos_e
xyloses1746843xyloses
yogin98317743_y_ogin
zygosis20405953zygosis
zymosan2143803zymosan
zymosis21487493zymosis

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 Filter1786911340270.563317390.8
2DLD Change Limit134027696.84619577.4
3Display Results69690.0135307.7
 (SQL Overall)178691697.42224075.9
 
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.