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 “pyramidical” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

54 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
pyramidical215280(None) 
paramedical18114402paramedical
pyramidal1744012pyramid__al
pyramidic1943772pyramidic__
paradisical1653773paradisical
paramedicals19142773paramedicals
parasitical1555653parasitical
premedical1745313p_remedical
pyramiding1943533pyramidi_ng
pyritical1646983pyr__itical
aeromedical1653374aeromedical
bipyramidal216944bipyramid__al
biradical14105324bira__dical
druidical1343014_dr_uidical
dynamical1743894dynam__ical
eremitical1444774_eremitical
fatidical1544244__fatidical
juridical1943704jur__idical
miracidial1552294miracidi_al
pacifical1845234p__acifical
paradisaical1762574paradisaical
paradisal1246884para__disal
paradisiacal1761704paradisiacal
paradisial1354804paradisi_al
paradoxical2353254paradoxical
paramedic1645724paramedic__
paramedics1744154paramedic_s
parapodial1554914parapodi_al
parodical1447564p__arodical
peridial11411924per__idi_al
periodical1546814per_iodical
piratical1348674pira__tical
practical1548844p_ra_ctical
praedial1178764p_ra_edi_al
pragmatical1854904p_ragmatical
prandial1149644p_ra_ndi_al
presidial1247214p_residi_al
prosodical1545594p_rosodical
pycnidial1752484py_cnidi_al
pygidial1543304py__gidi_al
pyralidid1653644pyralidi__d
pyralidids1752144pyralidi_ds
pyramid1547514pyramid____
pyramidally2252484pyramidally
pyramided1873834pyramid__ed
pyramids1645644pyramid___s
pyridic15267834pyr__idic__
pyridoxal2252134pyr__idoxal
pyrimidine1852554pyrimidi_ne
pyrimidines1952174pyrimidines
pyromaniacal2161964pyromaniacal
radical103312794__ra__dical
tyrannical1553214tyra_nnical
veridical1545984ver__idical

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819549.39015848.7
3Display Results54540.0331636.4
 (SQL Overall)178691549.84318154.1
 
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.