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

113 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
amylose123718(None) 
amylase1237011amylase
amyloses1347211amyloses
amylases1346652amylases
amylene12106872amylene
amylogen1444252amylogen
amyloid1348532amyloid
amyls104512682amyl_s_
ankylose1544172ankylose
hamulose1344282hamulose
ramulose1044312ramulose
xylose1636762_xylose
abalone938893abalone
acaulose1044383acaulose
acerose9310893acerose
acetose938843acetose
acinose938573acinose
acylate12310533acylate
acyloin1247453acyloin
acyls104211523acyl_s_
adipose1036653adipose
agarose838653agarose
aldose7311093a_ldose
aloe45540193a__lo_e
aloes54933673a__loes
alone55732963a__lone
amarone9311193amarone
amble95924633ambl__e
ambles105121853ambles_
ambos95321243am_bos_
amidase1036723amidase
amidone10349303amidone
amigos94511203amigos_
amitoses1039053amitoses
ammos94815823am_mos_
amnios84912513amnios_
amniote936963amniote
amole75724593am__ole
amoles84122193amoles_
amoroso946093amoroso
ample94720303ampl__e
amplest11312333amplest
amuse75920833am__use
amyl95515093amyl___
amylenes13105703amylenes
amylic13108703amyl_ic
amylogens1543603amylogens
amyloids1445983amyloids
amylopsin1652793amylopsin
amylum1344683amyl_um
amylums1473603amylums
analyse10208893analyse
anchylose1743073anchylose
anglos74413903anglos_
angulose945163angulose
ankylosed1742733ankylosed
ankyloses1644283ankyloses
annulose844473annulose
anymore1256243anymore
anyone94612733any_one
anywise1345203anywise
appose10411993a_ppose
apyrase1236363apyrase
arenose7311373arenose
ariose64818723a_riose
arkose104911343a_rkose
arose55832083a__rose
aryls87015813aryl_s_
aslope839013a_slope
aslosh966233a_slosh
avulse935843avul_se
azygos1933323azygos_
azygoses2163313azygoses
callose9313653callose
close76425223__close
cymose13429653_cymose
employe1476363employe
enclose999993enclose
filose96112503_filose
gyrose105310253_gyrose
implode12156103implode
implore11176703implore
impose103113043im_pose
inclose9910223inclose
ladylove1542013ladylove
lamellose1143523lamellose
laminose1036913laminose
lose45144583___lose
maltose939783maltose
mannose939243mannose
mayos105521933may_os_
maypole1446383maypole
milos75428013_milos_
moose76327193_m_oose
morose85116243_morose
mucose10149313_mucose
mycoses1437723_mycoses
myope124010973_my_ope
myoses114013843_my_oses
mysost1138263_mysost
papulose1244533papulose
parclose1247243parclose
pilose84514233_pilose
ramose8314403ram__ose
sabulose1044613sabulose
stylise10208953stylise
tumulose1043553tumulose
unclose91111643unclose
vamoose1235863vam_oose
vamose1159283vam__ose
villose1038053villose
xyloses1746843_xyloses
zygose19455553_zygose

Search took 9 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.1561145455.1
2DLD Change Limit1340271138.58015620.9
3Display Results1131130.0601883.3
 (SQL Overall)1786911138.79620315.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.