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

165 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
glycin123596(None) 
glycan1234901glycan
glycine1335711glycine
glycins1335561glycins
aglycon1342782aglycon
glacis94012132glacis
globin9309722globin
glucan936182glucan
glycans1344232glycans
glycerin1444352glycerin
glycines1445082glycines
glycol1254932glycol
glycyl1542792glycyl
lysin84512782_lysin
aglycone1442873aglycone
aglycons1442973aglycons
alanin6317273alanin
alcid85817973al_cid
aldrin7311243aldrin
alevin92511513alevin
alexin132311483alexin
algin65718763al_gin
allicin949953allicin
aloin55227423al_oin
alumin8513543alumin
ayin76331743_ay_in
blain75421793bl_ain
blin67228173bl__in
brucin1049133brucin
calycine1546963calycine
colicin11313743colicin
cyclin1339273_cyclin
elain55324703el_ain
elfin84312463el_fin
elicit8417203elicit
eloin55923203el_oin
elysian1065083elysian
ficin103516723_ficin
flacon1138633flacon
flavin1239303flavin
florin9312653florin
flying134612153fly_ing
flyman14326423flyman
flymen14387773flymen
flyting14378553flyting
folacin1238053folacin
gaijin1445983gaijin
gain56042163g__ain
gallein8299043gallein
gamin84423003g_amin
garcon92912483garcon
gascon9339723gascon
gaskin113610583gaskin
gelatin83514733gelatin
gin46055753g___in
gittin72910553gittin
glace87420153glac_e
glaceing1236533glaceing
glaces94218023glaces
glacial1038143glacial
glacier103911293glacier
glair65313553gl_air
glancing1247063glancing
glaring93714883glaring
glazing183611003glazing
glean65818203gl_ean
glen56027203gl__en
gleying12318433gleying
glia56423153gl__ia
gliadin935593gliadin
glib79421443gl__ib
gliding103911843gliding
glim76026353gl__im
gliming113310133gliming
glint66830183gl__int
globing113210003globing
globins10278953globins
glochid1445263glochid
glonoin875673glonoin
gloria71910543gloria
gloving12308443gloving
glowing123211793glowing
glozing18338893glozing
glucans1045293glucans
glucinic1363743glucinic
glucinum1343203glucinum
glueing9338713glueing
gluing83812053gl_uing
gluon6311223gl_uon
gluten74210753gluten
glyceric1643933glyceric
glycerine1544703glycerine
glycerins1544553glycerins
glycogen1543063glycogen
glycolic1643963glycolic
glycols1344133glycols
glyconic1644613glyconic
glycyls1642063glycyls
glyph1456473gly_ph
glyphic1844063glyphic
glyphs1534303glyphs
glyptic1544503glyptic
goblin939503goblin
goyim1148603goy_im
gracing113216443gracing
gradin83517483gradin
grain65126253g_rain
gratin74520583gratin
grin55733723g__rin
groin65521083g_roin
guanin7610803guanin
guying11379723guy_ing
guyline11258173guyline
gybing13355933g_ybing
gyri85415153g_yri_
gyring113910363g_yring
gyron95314623g_yron
gyving14415713g_yving
lacing94626233_lacing
lain46146283_l_ain
lapin75222923_lapin
layin84720333_layin
lectin82515013_lectin
leucin839113leucin
levin84816413_levin
licit74327683_licit
lin37967373_l__in
linin58025523_linin
lipin75518893_lipin
loci66126283_loci_
login66025003_login
loin46838723_l_oin
lucid84314573_lucid
lupin75215843_lupin
lycea10418943_lycea
lycee104716743_lycee
lych126015763_lyc_h
lycra10317973_lycra
lying95717453_ly_ing
lyric104512723_lyric
lysine94210553_lysine
lysing104710443_lysing
lysins94610953_lysins
lysis84511463_lysis
lytic104513033_lytic
mayvin1436523mayvin
mucin93116823_mucin
niacin8310223niacin
olefin937583olefin
olein5316003ol_ein
orcin72716573_orcin
phytin14459013phytin
placid114012543placid
placing123815283placing
plain74823303pl_ain
plying124312083ply_ing
pyin96823233_py_in
ricin74620213_ricin
salicin9311223salicin
slain54923573sl_ain
slicing103514643slicing
sylvin12247303sylvin
tyin76424003_ty_in
yin67648733__y_in
zayin174512043zay_in

Search took 10 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.423422437.4
2DLD Change Limit1127161658.51613235.8
3Display Results1651650.0463587.0
 (SQL Overall)1786911658.98519887.7
 
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.