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

121 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
parodist1141276(None) 
parodists1248511parodists
sarodist9510921sarodist
paradise112113872paradise
parodic122311722parodi_c
parodied1238332parodied
parodies11313692parodies
parodistic1546802parodistic
parodos103011752parodos_
protist9320222p_rotist
sarodists1056592sarodists
agonist82615403_agonist
amorist9317643_amorist
aorist64827873_a_orist
aphorist13412503aphorist
arborist10411613_arborist
aridest8316143_aridest
aroids75118223_aroids_
aroint6328153_aro_int
arsonist8412013_arsonist
artist64125543_ar_tist
atomist92915763_atomist
canoeist10310693canoeist
canonist10513533canonist
darndest1067223darndest
faddist12289643fa_ddist
faradise12219393faradise
faradism14188373faradism
grodiest10310553_grodiest
hagadist1347603hagadist
hardest113118413har_dest
hardiest123416333har_diest
harmonist141310663harmonist
harpist12312353har_pist
ironist7314843_ironist
jargonist1746703jargonist
lapidist1147833lapidist
lardiest93813883lar_diest
melodist1149743melodist
monodist11310923monodist
narcist9512443nar_cist
odist6421913___odist
pacifist1548093pacifist
padis86227143pa__dis_
padronism1445493padronism
paganist11411813paganist
pagodas11367553pagodas_
pagods105310193pagod_s_
palmist112814343pa_lmist
paludism1345323paludism
pandit93820753pa_ndi_t
pandits103914213pa_ndits
panelist10414503panelist
papist102618743pa__pist
parades104121463parades_
paradigm1446243paradigm
parading12313863parading
paradisal1246883paradisal
paradises122513203paradises
parados103816053parados_
parchisi15368933parchisi
pardi85723953par_di__
pardie96021443par_di_e
pardine103616723par_dine
pardons103817623pardons_
pards85634333par_d_s_
parecism1458533parecism
paresis93315093paresis_
parfait12312053parfai_t
parfaits1346913parfaits
paris75145943par__is_
parish115022353par__ish
parodical1447563parodical
parodoi10267723parod_oi
parody12410093parod__y
parodying1655423parodying
paroles95025883paroles_
paroling113316213paroling
parols84722613paro_ls_
paroquet1947283paroquet
parotic112518043paroti_c
parotid102915513paroti_d
parotids112610413parotids
parous84024163paro_us_
paroxysm2242733paroxysm
parsonish1446323parsonish
parvis116114803par_vis_
parvise124211693par_vise
patois84319363pato_is_
patronise1198443patronise
persist9315853per_sist
pogromist1445313pogromist
poloist91016323polo_ist
predict12315323p_redict
probit103218353p_robi_t
probits112712573p_robits
prodigy1435573p_rodigy
prods85523553p_rod_s_
product1279233p_roduct
profit113016273p_rofi_t
profits122911243p_rofits
promise113415843p_romise
prosaist10611583p_rosaist
prosiest10416523p_rosiest
prosit85124593p_rosi_t
prosodist1248913prosodist
prost75434103p_ro__st
protest9317533p_rotest
protists10313363p_rotists
proudest1138943p_roudest
proviso1237313p_roviso
provost1238573p_rovost
prowest12311533p_rowest
prudish1376563p_rudish
purist85525053pur__ist
pyrosis12411653pyrosis_
sadist74221353sa__dist
sarodes84216143sarodes_
sarods74918573sarod_s_
sparoids11218713sparoids_
tardiest93515243tar_diest

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621218.04618165.8
3Display Results1211210.0462630.4
 (SQL Overall)1786911218.26521620.2
 
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.