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

111 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
amylase123701(None) 
amylases1346651amylases
amylose1237181amylose
acylate12310532acylate
amidase1036722amidase
amylene12106872amylene
amyloses1347212amyloses
amyls104512682amyl_s_
apyrase1236362apyrase
abase76023483a__base
ablate82219213a_blate
ablaze17239833a_blaze
acrylate1347693acrylate
acylated1437863acylated
acylates1339743acylates
acyls104211523acyl_s_
adulate8313233adulate
aflame1138723a_flame
aglare7312423a_glare
akelas10311193akelas_
alae45643753a__la_e
alane56135613a__lane
alas46358123a__las_
alate55340323a__late
aldolase944773aldolase
alkylate1554663alkylate
alulae6312743alula_e
amas67746293am__as_
amass77119683am__ass
amaze166016603am__aze
ambage11510603am_bage
amble95924643ambl__e
ambles105121863ambles_
ambsace1355963ambsace
ambulate1239733ambulate
amebae1049633ameba_e
amebas10311453amebas_
amesace1147733amesace
amias75831473am_ias_
amidases1136643amidases
amigas95912163amigas_
amirate91115953amirate
amole75724593amol__e
amoles84122193amoles_
ample94720303ampl__e
amplest11312333amplest
amuse75920833am__use
amygdale1541923amygdale
amyl95515093amyl___
amylenes13105703amylenes
amylic13108703amyl_ic
amylogen1444253amylogen
amyloid1348533amyloid
amylum1344683amyl_um
amylums1473603amylums
analyse10208893analyse
anatase738943anatase
ankylose1544173ankylose
anlace82513923a_nlace
anlage72514223a_nlage
anlas55626933a_nlas_
anlases72514903a_nlases
anyplace1543853anyplace
anywise1345203anywise
appease1137913appease
applause1243663applause
apyrases1337243apyrases
aryls87015813aryl_s_
asyla839333asyla__
atlas55821583a_tlas_
atlases72410643a_tlases
avulse935843avul_se
blase75524233__blase
boylas113011723boylas_
catalase1039213catalase
cyclase1436613cyclase
emblaze2045773emblaze
emplace1338263emplace
emplane11410013emplane
emulate9314123emulate
enolase7310193enolase
euclase938933euclase
gyrase10508773_gyrase
hamulate1359013hamulate
hamulose1344283hamulose
haylage1436443haylage
hylas114815903_hylas_
imblaze2044323imblaze
inulase739413inulase
kamalas13339123kamalas_
lase46148513___lase
lyase85512413_ly_ase
malaise9312673_malaise
malate84624553_malate
maltase938903maltase
mayas105924383may_as_
milage93414123_milage
molas75132093_molas_
mutase82811983_mutase
myases113711553_my_ases
myiases1235493_myiases
mylar105311533_myla_r
mylars114310443_mylars
mynas105815233_mynas_
phylae14458733phyla_e
ramblas112710263ramblas_
ramulose1044313ramulose
stylate10179773stylate
stylise10208953stylise
xylose1636763_xylose
zymase201997483_zymase

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271117.03019065.0
3Display Results1111110.0333363.6
 (SQL Overall)1786911117.21924752.9
 
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.