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

126 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
glycine133571(None) 
glycin1235961glycin_
glycines1445081glycines
glycins1335561glycins
aglycone1442872aglycone
calycine1546962calycine
glycan1234902glycan_
glycans1344232glycans
glycerine1544702glycerine
guyline11258172guyline
lysine94210552_lysine
aglycon1342783aglycon_
aglycones1553023aglycones
aglycons1442973aglycons
alanine7316863alanine
alexine142410543alexine
aline57243153al__ine
alkine104916803al_kine
alpine84417373al_pine
alumine9412693alumine
alvine94614583al_vine
brucine1138273brucine
byline11311643_byline
calcine11315273calcine
cine66242943___cine
cline76428533cl__ine
colicine12312993colicine
crocine11314153crocine
culicine1248343culicine
elapine9310673elapine
fascine12510583fascine
flavine1338453flavine
flying134612153fly_ing
flyting14378553flyting
gamine94620153g_amine
gelatine93213303gelatine
genuine838373genuine
glace87420153glac__e
glaceing1236533glaceing
glacial1038143glacial
glaciate1168073glaciate
glacier103911293glacier
glacis94012133glaci_s
glacises1138503glacises
glaire74411293gl_aire
glaive10357933gl_aive
glancing1247063glancing
glaring93714883glaring
glassine9329313glassine
glazing183611003glazing
gleying12318433gleying
gliadine1045403gliadine
glide74521593gl__ide
gliding103911843gliding
glime85620193gl__ime
gliming113310133gliming
glint66830183gl__int
globin9309723globin_
globing113210003globing
globins10278953globins
gloving12308443gloving
glowing123211793glowing
glozing18338893glozing
glucan936183glucan_
glucans1045293glucans
glucinic1363743glucinic
glucinum1343203glucinum
glucose1045113glucose
glueing9338713glueing
gluing83812053gl_uing
glyceride1644093glyceride
glycerin1444353glycerin_
glycerines1644453glycerines
glycerins1544553glycerins
glycogen1543063glycogen
glycol1254933glyc_ol
glycols1344133glycols
glyconic1644613glyconic
glycoside1654063glycoside
glycyl1542793glyc_yl
glycyls1642063glycyls
gracile102512603gracile
gracing113216443gracing
gradine93317033gradine
gratine84719193gratine
grecize1935663grecize
guanine8810543guanine
gumline102810113gumline
guying11379723guy_ing
guylines12236943guylines
gwine95513663g__wine
gybing13355933g_ybing
gyrene10227243g_yrene
gyring113910363g_yring
gyving14415713g_yving
hircine1239143hircine
lacing94626233_lacing
lacune8169673_lacune
larine63927043_larine
lawine93316463_lawine
leucine938073leucine
line46965573_l__ine
lucite8313343_lucite
lupine84013533_lupine
lycee104716743_lyc_ee
lychee143710893_lychee
lying95717453_ly_ing
lysin84512783_lysin_
lysines10369093_lysines
lysing104710443_lysing
lysins94610953_lysins
olefine1038023olefine
oleine6313793ol_eine
olivine1038843olivine
oscine8311563_oscine
phocine1438833phocine
piscine11610973piscine
placing123815283placing
plying124312083ply_ing
porcine11312843porcine
salicine10311703salicine
skyline1436793skyline
slicing103514643slicing
sylvine13216543sylvine
thymine1536643thymine
vaccine1437323vaccine

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.390458182.1
2DLD Change Limit1340271265.71623447.7
3Display Results1261260.0502520.0
 (SQL Overall)1786911266.15629027.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.