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

47 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
glyconic164461(None) 
glycolic1643961glycolic
glyconics1743571glyconics
glucinic1363742glucinic
glucosic1353592glucosic
glyceric1643932glyceric
laconic1139882_laconic
aglycon1342783aglycon__
aglycone1442873aglycon_e
aglycones1553023aglycones
aglycons1442973aglycon_s
clonic104914673cl__onic
conic95329793___conic
cryonic1437833cry_onic
cyclonic1446973_cyclonic
draconic1346193draconic
geoponic1347213geoponic
glycan1234903glycan__
glycans1344233glycan_s
glycerin1444353glycerin
glycin1235963glyc__in
glycine1335713glycin_e
glycines1445083glycines
glycins1335563glycin_s
glycogen1543063glycogen
glycol1254933glyco__l
glycols1344133glyco_ls
glycolytic2153043glycolytic
glycoside1654063glycoside
glycosidic1952293glycosidic
glycosyl1752193glycosyl
glyphic1844063gly_phic
glyptic1544503gly_ptic
gnomonic1345903gnomonic
iconic10411593__iconic
lactonic1248043_lactonic
lychnis1544383_lychnis
mycotic1647713_mycotic
obconic1346353_obconic
phytonic1848203phytonic
platonic1238773platonic
pleonic1139433pl_eonic
plutonic1246103plutonic
syconia1248313_syconia
tyronic1239313_tyronic
yonic105920843__y_onic
zirconic2144013zirconic

Search took 7 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.406440125.6
2DLD Change Limit146162476.25023385.9
3Display Results47470.0301566.7
 (SQL Overall)178691476.68626726.1
 
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.