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

100 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
glycines144508(None) 
glycine1335711glycine_
glycins1335561glycin_s
aglycones1553022aglycones
glacises1138502glacises
glycans1344232glycan_s
glycerines1644452glycerines
glycin1235962glycin__
guylines12236942guylines
lysines10369092_lysines
aglycone1442873aglycone_
aglycons1442973aglycon_s
alanines8314803alanines
alexines15258503alexines
alines65735223al__ines
alkines114415733al_kines
alpines94016193al_pines
alumines10411683alumines
brucines1237763brucines
bylines1239243_bylines
calcines12314753calcines
calycine1546963calycine_
cines75239683___cines
clines84926043cl__ines
colicines13311203colicines
culicines1347013culicines
fascines13310143fascines
flamines13311643flamines
flavines1437893flavines
flyings14496063fly_ings
flytings15304793flytings
gamines103618463g_amines
gaywings1633193gaywings
gelatines102910533gelatines
glaces94218023glac__es
glaciates1267343glaciates
glacier103911293glaci_er
glaciers11277893glaciers
glacis94012133glaci__s
glaires84010133gl_aires
glaives11347833gl_aives
glariness1038553glariness
glassines10278043glassines
glaziness1935753glaziness
glazings19325753glazings
gleyings13283653gleyings
gliadines1144773gliadines
glides84518863gl__ides
glimes94717523gl__imes
glints75714213gl__ints
globins10278953globin_s
glories81915913glori_es
glucans1045293glucan_s
glucinic1363743glucinic
glucinum1343203glucinum
glucinums1442293glucinums
glucoses1145333glucoses
gluiness937363gl_uiness
glycan1234903glycan__
glycerides1744103glycerides
glycerine1544703glycerine_
glycerins1544553glycerin_s
glycogen1543063glycogen
glycogens1643123glycogens
glycols1344133glyc_ols
glyconic1644613glyconic
glyconics1743573glyconics
glycosides1764073glycosides
glycyls1642063glyc_yls
graciles112511613graciles
gradines103615253gradines
grecizes2035683grecizes
guanines989773guanines
gumlines11238573gumlines
guyline11258173guyline_
gyrenes11267523g_yrenes
laciness102112553_laciness
lacings105013653_lacings
lacunes9159623_lacunes
lawines103313563_lawines
leucines1037273leucines
lines57054573_l__ines
lucites9311863_lucites
lupines93912503_lupines
lycees11428863_lyc_ees
lychees15516783_lychees
lyches144213613_lyc_hes
lychnis1544383_lychnis
lyings10488503_ly_ings
lysine94210553_lysine_
lysins94610953_lysin_s
olefines1137323olefines
oleines7313393ol_eines
olivines1137473olivines
oscines9310363_oscines
salicines11310003salicines
skylines1535703skylines
sylvines14215903sylvines
thymines1635613thymines
vaccines1536503vaccines

Search took 8 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.423422437.4
2DLD Change Limit1461621006.75021653.6
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.20324807.9
 
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.