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

55 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
parodical144756(None) 
paradisal1246882paradisal
parodic122311722parodic__
periodical1546812periodical
prodigal1246002p_rodigal
acronical1347833acronical
alodial899953_alodi_al
alogical1147763_alogical
atomical1248903_atomical
baronial1049483baroni_al
biradical14105323biradical
canonical1347213canonical
cardinal1139573car_dinal
carotidal1245133carotidal
episodical1552993episodical
erotical101911983_erotical
farcical1546953far_cical
fatidical1544243fatidical
heroical13410023hero_ical
ironical1049963_ironical
juridical1943703juridical
monodical1447003monodical
nodical1049863__nodical
pacifical1845233pacifical
pantropical1764363pantropical
paradisial1354803paradisial
paradisical1653773paradisical
paradoxical2353253paradoxical
paramedical18114403paramedical
parapodial1554913parapodi_al
parfocal1565393par_focal
parochial1646183parochial
parodied1238343parodi_ed
parodies11313693parodi_es
parodist11412763parodi_st
parodists1248513parodists
parotic112518043parotic__
partial92616263par_ti_al
peridial11411923peridi_al
periodicals1664073periodicals
piratical1348673piratical
practical1548843practical
praedial1178763praedi_al
prandial1149643prandi_al
predial103815413p_redi_al
prodigals1344233p_rodigals
prosaical1346973p_rosaical
prosodical1545593prosodical
proviral1346493p_roviral
proximal1945183p_roximal
pyritical1646983pyritical
radical103312793__radical
synodical1544793synodical
tropical1248733_tropical
veridical1545983veridical

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 Filter1786911486410.423422437.4
2DLD Change Limit148641559.42015779.3
3Display Results55550.063873.0
 (SQL Overall)178691559.90618038.7
 
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.