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

66 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
amyloids144600(None) 
amyloid1348541amyloid_
acyloins1345902acyloins
ambroids1346502ambroids
amyloses1347222amyloses
meloids10911452_meloids
acyloin1247463acyloi_n
adenoids1056863adenoids
alcids94812293a__lcids
alkaloids1443983alkaloids
allods73615083a_llo_ds
aloins65022203a__loins
amberoids1445333amberoids
ambroid1238883ambroid_
ameboid1277233ameboid_
amids85627513am___ids
ammonoids1493523ammonoids
amygdaloids1961193amygdaloids
amylases1346663amylases
amylenes13105703amylenes
amylic13108713amyl_i_c
amylogen1444263amylogen
amylogens1543603amylogens
amyloidoses1752013amyloidoses
amyloidosis1761803amyloidosis
amylopsins1752583amylopsins
amylose1237193amylo_se
amyls104512693amyl___s
amylums1473613amyl_ums
androids1047753androids
aneroids9310203aneroids
armloads1144233armloads
aroids75118223a__roids
avoids104410203a__voids
camelids1356943camel_ids
cheloids1438033cheloids
colloids11310173colloids
cycloids1647043cycloids
diploids1247843diploids
emeroids11147723emeroids
emulsoids1242603emulsoids
euploids1157243euploids
haloids113012553_haloids
haploids1437363haploids
hyaloids1545993hyaloids
hyoids1377673_hy_oids
keloids1288663_keloids
limuloids1243183limuloids
loids66220703___loids
mastoids1177873mastoids
mattoids1196183mattoids
meloid9616003_meloid_
milords10117853_milords
mucoids1237423_mucoids
myeloid13108123_myeloid_
myoid11512993_my_oid_
mysids1246563_my_sids
myxoid1936883_myxoid_
payloads1445293payloads
phylloids1844523phylloids
psyllids1443023psyllids
sloids73712693__sloids
styloid1137553styloid_
tabloids1146163tabloids
thyroids1546003thyroids
xyloid1738193_xyloid_

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.406440125.6
2DLD Change Limit146162666.70321805.5
3Display Results66660.0302200.0
 (SQL Overall)178691667.13925030.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.