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

132 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
glycan123490(None) 
glucan936181glucan
glycans1344231glycans
glycin1235961glycin
aglycon1342782aglycon
flyman14326422flyman
glean65818202gl_ean
glucans1045292glucans
glycine1335712glycine
glycins1335562glycins
glycol1254932glycol
glycyl1542792glycyl
aglycone1442873aglycone
aglycons1442973aglycons
alan46844083al__an
ashcan1135843ashcan
bayman133712703bayman
billycan1543223billycan
can57760143___can
cancan10314103cancan
cayman133613213cayman
clachan1437183clachan
clan65633923cl__an
claypan1434313claypan
clean75420413cl_ean
cyan96419623_cy_an
cycad13507273_cycad
cycas126513823_cycas
elan46734243el__an
elysian1065083elysian
flacon1138633flacon
flan76134183fl__an
flymen14387773flymen
flyway18134693flyway
frypan1434543frypan
gagman103811243gagman
gallican1155333gallican
galyac1235973galy_ac
galyacs1335273galyacs
galyak1445333galy_ak
gan48060133g___an
garcon92912483garcon
gascon9339723gascon
gasman92911743gasman
gayal9312713gay_al
gaydar1135503gaydar
gelcap1136213gelcap
german9611983german
glace87420153glac_e
glaces94218023glaces
glacial1038143glacial
glacis94012133glacis
glad65624013gl__ad
glam76529343gl__am
gland75217713gl__and
glans65125833gl__ans
gleam86916733gl_eam
gleans75014743gl_eans
gleba83910243gleba_
glebae9407613glebae
gleeman1035363gleeman
glen56027203gl__en
glia56423153gl_ia_
glial66715433gl_ial
glias64618493gl_ias
gloam86015943gl_oam
gloat65427683gl_oat
global937663global
globin9309723globin
glucagon1241823glucagon
gluon6311223gl_uon
gluten74210753gluten
glycerin1444353glycerin
glycines1445083glycines
glycogen1543063glycogen
glycols1344133glycols
glyconic1644613glyconic
glycyls1642063glycyls
glyph1456473gly_ph
glyphs1534303glyphs
goban84414073g_oban
gossan747233gossan
gowan95415743g_owan
gran56335013g__ran
groan65618423g_roan
guan55325583g__uan
gunman9299453gunman
gyral94412783g_yral
gyron95314623g_yron
lagan66520343_lagan
lauan55216793_lauan
layman113511303layman
lean46345243_l_ean
leman75622603_leman
ligan67920283_ligan
liman75921603_liman
loan47436453_l_oan
loca65527683_loca_
local74820273_local
lochan1139093_lochan
logan68123283_logan
loran55925093_loran
lycea10418943_lycea
lycee104716743_lycee
lych126015763_lyc_h
lycra10317973_lycra
lycras11287253_lycras
lyncean1292923_lyncean
lysin84512783_lysin
mayan105616903may_an
oilcan837793oilcan
pecan91919033_pecan
pelican1139433pelican
plan65833943pl__an
platan83913693platan
plica9613373plica_
plicae10410953plicae
plical10411683plical
pyran10514473_pyran
scan65530453__scan
siccan1037593siccan
skycap1742913skycap
skyman1535313skyman
slogan7539223slogan
sylvan12257363sylvan
toucan838193toucan
ulan46527393ul__an
ulpan7310123ul_pan
wiccan1335033wiccan
xylan1537463_xylan
yean75834583__yean
yuan76120013__yuan

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161325.45320670.5
3Display Results1321320.0462869.6
 (SQL Overall)1786911325.88930343.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.