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

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
pyranosides175305(None) 
pyranoside1653141pyranoside_
furanosides1552222furanosides
pyranoses1445852pyranos__es
furanoside1452153furanoside_
paranoids1248913parano_id_s
planesides1354373p_lanesides
pyranoid1447283pyrano_id__
pyranose1344923pyranos__e_
pyrenoids1544803pyreno_id_s
pyrosises1457583pyr__osises
arabinosides1551564_arabinosides
banksides16104854__banksides
burnsides1244234bur_n_sides
cyanamides1842954cy_anamides
cyanides14258004cy_an__ides
cyanoses1337424cy_anos__es
cyanosis1346274cy_anosi__s
furanoses1244994furanos__es
grandsires1245044_grandsires
gravesides1543744_gravesides
guanosines1143634_guanosines
hyracoids1844254hyraco_id_s
ironsides1045294_iron_sides
landsides11116744__landsides
pansies94521984p__an_si_es
paradoses122510254parados__es
paraglides1445014para_glides
paranoiacs1444254parano_iacs
paranoias11410444parano_i_as
paranoics1347654parano_i_cs
paranoid11311144parano_id__
paranoidal1354894parano_idal
parasites11313154para__sites
pentosides1365044p_entosides
peroxides1947494per__oxides
phenoxides2353894p_henoxides
phrenitides1753714phrenitides
phrensies1445744phren_si_es
planeside1285124p_laneside_
presides11414914p_r__esides
proboscides1862584p_roboscides
protoxides2046284p_rotoxides
provides1439884p_r__ovides
pycnoses1554974py_cnos__es
pycnosis1554734py_cnosi__s
pyknoses1783574py_knos__es
pyknosis1753644py_knosi__s
pyralidids1752144pyralidid_s
pyralids1445814pyra__lid_s
pyramided1873834pyra__mided
pyramids1645644pyra__mid_s
pyrenoid1446874pyreno_id__
pyridoxines2452124pyridoxines
pyrolizes2347234pyr__olizes
pyrologies16310014pyrologi_es
pyrolusites1652394pyrolusites
pyronines1458324pyr__onines
pyrosis12411654pyr__osi__s
pyrrhotites1951624pyrrhotites
ringsides1144744__ringsides
tracksides1744164_tracksides
transudes1047594_tran_sudes
tyrannicides1861704tyrannicides
tyrannies1255534tyran_ni_es
tyrannises1383974tyran_nises
tyrannizes2263474tyran_nizes
tyrosines1246864tyr__osines
uranides92211284_uran__ides

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 Filter1786911488190.423422437.4
2DLD Change Limit148819698.28017973.3
3Display Results69690.0332090.9
 (SQL Overall)178691698.73620454.6
 
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.