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 “glycans” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
glycans134423(None) 
glucans1045291glucans
glycan1234901glycan_
glycins1335561glycins
aglycons1442972aglycons
glans65125832gl__ans
gleans75014742gl_eans
glucan936182glucan_
glycin1235962glycin_
glycine1335712glycine
glycines1445082glycines
glycols1344132glycols
glycyls1642062glycyls
aglycon1342783aglycon_
aglycone1442873aglycone
aglycones1553023aglycones
alans55636173al__ans
ashcans1235183ashcans
billycans1642873billycans
cancans11311873cancans
cans65050853___cans
caymans14349513caymans
clachans1546413clachans
clans75031013cl__ans
claypans1543873claypans
cleans85817053cl_eans
cyans105714813_cy_ans
cycads14476213_cycads
cycas126513823_cyca_s
elans55527753el__ans
flacons1238053flacons
flans85327973fl__ans
flyman14326423flyman_
flyways19133853flyways
frypans1544053frypans
galyacs1335273galy_acs
galyaks1534623galy_aks
garcons102411643garcons
gascons10289103gascons
gayals1039513gay_als
gaydars1235803gaydars
gelcaps1235203gelcaps
germans1079473germans
glaces94218023glac_es
glacis94012133glac_is
glads75620613gl__ads
glams85822933gl__ams
gland75217713gl__and
glands85314403gl__ands
glass65518133gl__ass
gleams94812253gl_eams
glean65818203gl_ean_
glens66519853gl__ens
glias64618493gl_ia_s
gloams95210663gl_oams
gloats74515423gl_oats
globins10278953globins
glucagons1341903glucagons
gluons738503gl_uons
glutens8437593glutens
glycerins1544553glycerins
glycogens1643123glycogens
glycol1254933glyc_ol
glyconic1644613glyconic
glyconics1743573glyconics
glycyl1542793glyc_yl
glyphs1534303gly_phs
gobans94412043g_obans
gossans836783gossans
gowans105512293g_owans
grans64832543g__rans
groans74815063g_roans
guans64419443g__uans
gyrons105511223g_yrons
lagans75717783_lagans
lauans65113533_lauans
leans55536253_l_eans
lemans85316393_lemans
ligans76817733_ligans
limans84816303_limans
loans56026463_l_oans
locals83714503_locals
lochans1248833_lochans
logans76319063_logans
lorans65117603_lorans
lycees11428863_lycees
lyches144213613_lyches
lychnis1544383_lychnis
lycras11287253_lycras
lysins94610953_lysins
oilcans936813oilcans
pecans101515833_pecans
pelicans1238093pelicans
plans75731273pl__ans
platans93413123platans
pyrans11411063_pyrans
scans74625103__scans
skycaps1842703skycaps
slogans8407983slogans
sylvans13235893sylvans
toucans937583toucans
ulans54921303ul__ans
wiccans1434603wiccans
xylans1635883_xylans
yeans86624883__yeans
yuans84613323__yuans

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271066.20321606.8
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.68526730.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.