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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
parodying165542(None) 
pandying15217662pa_ndying
parading12313862parad_ing
pardoning1338762pardoning
parlaying1537302parlaying
parleying1536112parleying
paroling113316212paro_ling
parrying14168132par_rying
partying14168892par_tying
prodding13189342p_rodding
aboding11410123_abod_ing
aproning11311793apro_ning
arousing93811803_arousing
arraying1238753_arraying
bandying15218073ba_ndying
barding113822893bar_d_ing
bloodying1643783bloodying
bodying1438973__bodying
brandying1654883brandying
caddying16225063ca_ddying
candying15188993ca_ndying
canopying1745063canopying
carding113922443car_d_ing
caroling113317003caro_ling
carolling1259413carolling
caroming133312963caro_ming
carousing1237893carousing
carrying14148373car_rying
embodying1843473embodying
eroding9314273_erod_ing
farding123716743far_d_ing
garoting10510703garo_ting
garotting1136113garotting
harrying15157643har_rying
imbodying1842713imbodying
larding92917873lar_d_ing
marooning1238593marooning
marrying14157233mar_rying
pacifying2045503pacifying
padding123412513pa__dding
paddling13218643pa_ddling
palsying1436233pa_lsying
panfrying1842993panfrying
paralysing16235553paralysing
paralyzing25185203paralyzing
parawing14310583par_awing
parbaking1877203parbaking
parboiling1545173parboiling
parceling1438443parceling
parching164313053par_ching
pardine103616733par_d_ine
parenting12611583parenting
pargeting1338283pargeting
parging113318603par__ging
paring94236493par___ing
parking143423043par__king
parling103823763par__ling
parodic122311723parod_i_c
parodied1238343parod_ied
parodies11313693parod_ies
parodist11412763parod_ist
parodoi10267723parodoi__
parody12410093parody___
parring103222063par__ring
parroting1239153parroting
parsing103819553par__sing
partaking1698673partaking
parting103527383par__ting
patrolling1345693patrolling
paying123722163pa___ying
phonying1745833p_honying
plodding13166343p_lodding
ploying132811573p_lo_ying
podding124113183p__odding
ponying133312123p__onying
praying133717323p_r_aying
predrying1645343p_redrying
preying133114553p_r_eying
priding113317543p_rid_ing
probing123314443p_ro_bing
producing1556143p_roducing
progging132610383p_rogging
promoing13310463p_romoing
pronging123511843p_ronging
proofing1439313p_roofing
propping122811673p_ropping
prosing103319383p_ro_sing
proving134214073p_ro_ving
prowling1449993p_rowling
prying124114803p_r__ying
purifying1835853purifying
purveying1843573purveying
pyrolyzing2843253pyrolyzing
ramrodding1542083ramrodding
rarefying1654693rarefying
rarifying1646313rarifying
rebodying1635003rebodying
rodding103814533__rodding
stroying122410593stro_ying
tarrying12146723tar_rying
varooming1545083varooming
varying1429723var__ying
waddying17204723wa_ddying
warding123918143war_d_ing
yarding123413143yar_d_ing

Search took 9 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 Limit1486411057.76619140.0
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.23521699.0
 
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.