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

98 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
amyloses134722(None) 
amylases1346661amylases
amylose1237191amylose_
amitoses1039052amitoses
amylase1237022amylase_
amylenes13105702amylenes
amylogen1444262amylogen
amylogens1543602amylogens
amyloids1446002amyloids
ankyloses1644282ankyloses
azygoses2163312azygoses
mycoses1437732_mycoses
myoses114013842_my_oses
xyloses1746842_xyloses
abalones1038753abalones
abioses9311493a_bioses
abysses1234863aby_sses
acidoses1136773acidoses
acylates1339743acylates
acyloins1345903acyloins
adenoses947903adenoses
adiposes1137173adiposes
agaroses938823agaroses
aldoses8311203a_ldoses
alkaloses13144853alkaloses
aloes54933673a__lo_es
amarones10311353amarones
amasses93912853am_asses
amauroses1144473amauroses
ambles105121863ambl__es
ambones11312683am_bones
amidases1136653amidases
amidones11348663amidones
amitosis1047203amitosis
amniotes1036603amniotes
amoles84122193am__oles
amuses85117943am__uses
amylene12106883amylene_
amyloid1348543amylo_id
amyloidoses1752013amyloidoses
amylopsin1652803amylopsin
amylopsins1752583amylopsins
amyls104512693amyl___s
amylums1473613amyl_ums
analyses11149963analyses
anchyloses1853543anchyloses
anemoses10159433anemoses
ankylose1544173ankylose_
ankylosed1742733ankylosed
ankylosis1643943ankylosis
anlases72514903a_nlases
apodoses1136653apodoses
apposes11511473a_pposes
apyrases1337243apyrases
arkoses113910833a_rkoses
atlases72410643a_tlases
avulses1035433avul_ses
calloses10313393calloses
closes85425593__closes
cycloses1538183cycloses
diploses111110323diploses
employes1555943employes
encloses10911053encloses
hamulose1344283hamulose_
haploses1338853haploses
implodes13106393implodes
implores12127043implores
imposes113213683im_poses
incloses101610533incloses
ladyloves1641793ladyloves
loses56742013___loses
maltoses1039853maltoses
mannoses1039083mannoses
maypoles1545993maypoles
meioses9310833_meioses
mioses84318853_m_ioses
mitoses9312183_mitoses
myases113711553_my_ases
mycosis1437763_mycosis
myiases1235493_myiases
myopes13419963_my_opes
myosis114012563_my_osis
mysosts1234543_mysosts
parcloses1347963parcloses
peploses1269473peploses
phyleses1645183phyleses
psiloses1036443psiloses
pyoses114314303_py_oses
ramulose1044313ramulose_
stylises11188943stylises
styluses11204773styluses
sycoses1249133_sycoses
uncloses10910943uncloses
vamooses1345523vam_ooses
vamoses1239143vam__oses
xylose1636763_xylose_
zygoses20436783_zygoses
zymoses21608693_zymoses

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.470380193.6
2DLD Change Limit146162987.45319611.2
3Display Results98980.0462130.4
 (SQL Overall)178691987.96922423.3
 
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.