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

79 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
peridium134902(None) 
aecidium1345282aecidium
iridium1046302_iridium
periderm1346802periderm
peridia10312362peridi_a
peridial11411922peridial
perineum1246522perineum
presidium1445302presidium
pygidium1753232pygidium
pyxidium2343132pyxidium
aerobium1246303aerobium
americium1554083americium
ascidium1344813ascidium
basidium1345103basidium
cerium10313763cer__ium
conidium1366643conidium
ctenidium1452523ctenidium
delirium1146583delirium
deriding112512933deriding
erbium1038083_er_bium
fermium1446353fer_mium
geranium1147053geranium
gonidium1244213gonidium
hesperidium1961873hesperidium
iridiums1144523_iridiums
medium113711623me__dium
meridian1147683meridian
nephridium1852213nephridium
oidium959813__oidium
oncidium1344823oncidium
paradigm1446243paradigm
peculium1455543peculium
peponium1467493peponium
perdie94718513per_di_e
perdu84216273per_d_u_
perdue93912633per_d_ue
perdus93711273per_d_us
perfidies1546603perfidies
perfidious1653673perfidious
periblem1445513periblem
pericardium1852553pericardium
periderms1444993periderms
peridot10514243perid_ot
peridots1138323peridots
periling11316863periling
perilous10310693perilous
perimysium1952033perimysium
periodic1348433periodi_c
periodid1248163periodi_d
periodids1345643periodids
perique1837523peri_que
periti8319953periti__
peritus9311803peri_tus
periwig1345163periwi_g
periwigs1444193periwigs
pieridine1246143pieridine
podium112911913p__odium
praesidium1552573praesidium
premium13310363p_remium
presidiums1543403presidiums
priding113317543p_riding
protium11312293p_rotium
pteridine1246743pteridine
pterygium1751923pterygium
puerilism1344763puerilism
pycnidium1952553pycnidium
pyridic15267833pyridi_c
pyridine1447743pyridine
radium93513293__radium
residuum1143063residuum
rubidium1343603rubidium
sedilium1145753sedilium
tedium9269873te__dium
terbium1147293ter_bium
triduum1043413_triduum
tritium969013_tritium
trivium1256143_trivium
uredium1076693_uredium
veridic1338143veridi_c

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.423422437.4
2DLD Change Limit146162796.75021653.6
3Display Results79790.0302633.3
 (SQL Overall)178691797.20324807.9
 
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.