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

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

340 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
perspicacity236195(None) 
perspicuity2052172perspic_uity
perspicacious2161393perspicacious
perspicacities2261993perspicacities
pertinacity1854103per_tinacity
efficacity2352054_e_fficacity
persnickety2261084persnic_kety
personality1656334pers_onality
perspicaciously2691334perspicaciously
perspiration1656834perspiration
perspiratory1952964perspiratory
physicality2453284phys_icality
veridicality2152784veridicality
verticality1955054ver_ticality
atypicality2152125_atypicality
bestiality1544775be_sti_ality
classicality1952905classicality
conspicuity2052135conspic_uity
criticality1854215_criticality
despicably2044315de_spica_bly
ethicality1853835_e_thicality
farcicality2153285far_cicality
feracity1646735fer____acity
hospitality1953485_hospitality
lexicality2254095le__xicality
musicality1745245_mus_icality
parfocality2152985par_focality
partiality1546785par_ti_ality
peculiarity1853295peculi_arity
periodicity1954205per_iodicity
pernickety2151705per_nic_kety
perpetuity1753005per_p_etuity
perplexity2452215per_p_lexity
personalty1555285pers_ona_lty
perspective2054865perspec_tive
perspicuities1952795perspicuities
perspicuous1752515perspic_uous
perspicuously2262365perspicuously
perspirations1786175perspirations
perspiring1544855perspi__ring
perspiry1543785persp____iry
plasticity1765605plasti__city
practicality2153595practicality
precocity1845915p_r__ecocity
predacity1745605p_r__edacity
prespecify2252445presp__ecify
primality1687335p_r__imality
prodigality18113665p_rodigality
prolificity2163125p_rolificity
propinquity2761455p_ropinquity
rapacity1544985__rap__acity
seismicity1752805seismi__city
spirality1446435___spirality
technicality2252725technicality
topicality1744485__topicality
typicality2053245__typicality
veracity1647555ver____acity
aerobically1848116aerobica_lly
aperiodicity2062126aper_iodicity
auspicate1345746_auspica__te
auspicating1644606_auspicating
basicity1546326_bas_i__city
bellicosity1851506be_llicosity
capacity1746026__cap__acity
cardinality1754356car_dinality
causticity1753826causti__city
centricity1746046centri__city
chronicity2054826chroni__city
comicality1946136__comicality
conspiracies1852896conspiracies
conspiracy1951976conspirac__y
cordiality1645626cor_di_ality
corporality1854656cor_porality
criminality1855226_criminality
cyclicality2052566_cyclicality
deistically1749046deistica_lly
delicacies1545136de__licacies
delicacy1644256de__licac__y
depravity1842806de__p_ravity
desiccant1444196de_s_iccant_
desiccants1542666de_s_iccants
desiccate1445926de_s_ic_cate
despicable1744986de_spica_ble
disparity1546396_disp__arity
edacity1336376_e____dacity
efficacies2052966_e_fficacies
efficacy2152526_e_fficac__y
elasticity1575386elasti__city
ellipticity1861996_ellipticity
epically15310586_e__pica_lly
epinasty1343136_e__pina_sty
eradicant1246936_eradica_nt_
eradicants1354246_eradica_nts
eradicate1259186_eradica__te
eradicating1556636_eradicating
eradication14410116_eradication
ergodicity1752996_er_godicity
eristically16411346_eristica_lly
erodibility1755966_erodibility
erosivity1544496_erosi__vity
erotically15414316_erotica_lly
ethnicity1744596_ethni__city
exsiccate2043146_exs_ic_cate
feasibility1945956feas_ibility
febricity1943816fe_bri__city
felicity1647926fe__li__city
ferocity1645996fer____ocity
fertility1547216fer_ti__lity
fervidity1943036fer_vi__dity
festivity1845116fe_sti__vity
geniality1347166ge__ni_ality
haruspication2051606haruspication
helicity1648506he__li__city
hereditarily1991846hereditarily
heretically19410686heretica_lly
heroically18410626her_oica_lly
hispidity1843406_hispi__dity
hypersexuality3272966hypersexuality
illogicality1862176illogicality
impersonality2063606impers_onality
incapacity1952646incap__acity
inhospitality2162056inhospitality
logicality1644186__logicality
marginality1754416mar_ginality
megacity1645716me____gacity
mendacity1744156me___ndacity
mendicity1745076me_ndi__city
meristically1949016meristica_lly
mesically16310096me_s_ica_lly
minacity1547376____minacity
mordacity1743516mor___dacity
opacity1436316___op__acity
operability1848856operabi__lity
operatically1949326operatica_lly
originality1554356_originality
overcapacity2462076over_capacity
overspicing1946546overspi__cing
pansexuality2462706pansexuality
paradoxicality2971466paradoxicality
parasexuality25122606parasexuality
partibility1847116par_tibility
particularity2064436par_ticularity
passivity1744106p_assi__vity
pasticci1443826p_astic_ci__
pasticcio1553206p_astic_ci_o
pasticcios1693046p_astic_cios
pecuniarily1851856pecuni_arily
penality13310716pe____nality
pepsinate1346636peps_ina__te
pepsinating1645376peps_inating
peracid12312996per____aci_d
peracids13310076per____acids
percaline13410956per___caline
perceivably2352726perceiva_bly
perceptibility2562946perceptibility
perceptivity2453426perceptivity
perfectivity2563856perfectivity
perianth1348556per__i_a_nth
periapt11313416per__i_a_pt_
periapts1237276per__i_a_pts
pericardia1553726per__icardia
pericardial1653626per__icardial
pericarditis1762136per__icarditis
pericardium1852556per__icardium
pericarp1446126per__ica__rp
pericarps1544476per__ica_rps
pericopic1745546per__icopi_c
pericrania1453806per__icrani_a
pericranial1553476per__icranial
pericranium1752906per__icranium
pericycle1843116per__icyc_le
pericycles1943086per__icycles
pericyclic1853016per__icyclic
peridotite1354926per__idotite
periodically2047596periodica_lly
peripety1546196per__i__pety
periphrasis1853176periphrasi_s
periphrastic2162696periphrastic
periplast1387286perip_la_st_
periplasts1475156perip_la_sts
perishability2365236perishability
perissodactyl217536perissodac_tyl
permeability2157176permeability
permissibility2362946permissibility
permittivity2271996permittivity
perquisite2153416perqui__site
persalt9315416pers___a_lt_
persalts1038196pers___a_lts
persecute1344886pers___ecute
persecuting1643836pers_ecuting
persecution1564786pers_ecution
persecutive1853936pers_ecutive
persecutory1852636pers_ecutory
persist9315856pers_i___st_
persistency1852656pers_istency
persistent1246036pers_istent_
persistently1752436pers_istently
persisting1346656pers_i_sting
persists1049186pers_i___sts
personalise1367106pers_onalise
personalism15137396pers_onalism
personalist1399426pers_onalist
personalists1476506pers_onalists
personalize2287336pers_onalize
personally1546946pers_ona_lly
personate112111426pers_ona__te
personating1447676pers_onating
personation1349486pers_onation
personative1647076pers_onative
personify1744016pers___onify
perspectival2162136perspectival
perspectively2553276perspectively
perspectives2153526perspectives
perspire1246666persp____ire
perspired1444226perspi___red
perspires1346666perspi___res
persuading1454506pers__uading
persuasion1294196pers__uasion
persuasive1553686pers__uasive
pertinacious1652806per_tinacious
pertinacities1754536per_tinacities
perversity1853476per__versity
pesticide1447286pe_sti__cide
petrification2048816petrification
physicalism2362786phys_icalism
physicalist2153876phys_icalist
physicalists2272986phys_icalists
physically2346106phys_ica_lly
piratically18411226piratica_lly
plastically1849406plastica_lly
popularity1754686p__opularity
positivity1854596p_os_itivity
possibility1855826p_ossibility
preciosity1754636p_reci_osity
predicant1449396p_redica_nt_
predicants1546066p_redica_nts
predicate14411786p_redica__te
predicating1749656p_redicating
predication16412436p_redication
predicative1947376p_redicative
predicatory1945576p_redicatory
preplacing1746006p_rep_lacing
presignify1952436pres_i_gnify
preslicing1546366presli__cing
prespecified2252596prespecified
prespecifies2152936prespecifies
presplit1247756presp___lit_
pricily142710286p_r__i__cily
primacies1548456p_r__imacies
primacy1635606p_r__imac__y
primarily1644676p_r__imarily
primitivity2153016p_rimitivity
principality2162666principality
priority1347446p_r__i_ority
privacies1646806p_r__ivacies
privacy1744236p_r__ivac__y
privity15268326p_r__i__vity
profanity1744796p_r__ofanity
prolixity2144866p_roli__xity
promiscuity2051576p_romiscuity
propensity1774676p_rop_ensity
prosaically1847846prosaica_lly
prosperity1754516prosp__erity
provinciality2362346p_rovinciality
proximity2344676p_roxi__mity
publicity1845036p_ubli__city
puerility1445996puer__i__lity
pugnacity1742566p___ugnacity
purification1948176purification
purificatory2272096purificatory
puristically1948206puristica_lly
pursuivant1551216pursuiva_nt_
pursuivants165926pursuiva_nts
pyrogenicity2364056pyrogenicity
quizzicality3461056quizzicality
rapidity1446276__rapi__dity
rascality1445996__r_ascality
reciprocity2051676recip_rocity
repacify1843486__rep__acify
respacing1438896re_sp__acing
respecify1943136re_sp__ecify
respiration13511196re_spiration
respiratory16104136re_spiratory
rusticity1445976_rusti__city
sagacity1445246___s_agacity
salacity1347856___s_alacity
scarcity1545096___s__carcity
seasonality1453466seas_onality
seismically1846256seismica_lly
sensibility1646906sens_ibility
sensitivity1753826sens_itivity
sensuality1344436sens__uality
septicity1646586se__p_ticity
sequacity2343826___sequacity
seraphically2256536seraphica_lly
servility1545856ser_vi__lity
sessility1244916se_ssi__lity
sociality1447956___sociality
spasticity1754266spasti__city
speciality1746336___speciality
specificity2382636spe__cificity
sphericity2053816spher__i__city
spicate113214196___spica__te
spiccato1463186___spic_cato
spicily1438656___spi__cily
spinachy1842796___spinac_hy
spinosity1444246___spinosity
subcavity1943386___subcavity
superficiality2462026super_ficiality
supersexuality2672886supersexuality
temporality1853676te_mporality
tenacity1347116te____nacity
tensility1245816tens_i__lity
tepidity1445606te__pi__dity
theatricality2181946theatricality
torpidity1543836tor_pi__dity
triplicity1753356_trip_licity
triviality1644446_trivi_ality
tropicalize2454316_tropicalize
tropically1749846_tropica_lly
varicosity1853086var__icosity
veniality1547596ve__ni_ality
veridically2046086veridica_lly
verification201810646verification
vermiculite1853556ver_miculite
versatility1755136vers_atility
versification21157496versification
vertically18410936ver_tica_lly
vesicant1347506ve_s_ica_nt_
vesicants1444756ve_s_ica_nts
vesicate131210056ve_s_ica__te
vesicating1646906ve_s_icating
vesicularity2062836ve_s_icularity
vespiaries1543586ve_spi_aries
vespiary1642746ve_spi_a__ry
vivacity1943996____vivacity
voracity1645536vor____acity
vorticity1746146vor_ti__city
whimsicality25101406whimsicality
xerically2149536xer__ica_lly

Search took 20 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 Filter1786911646070.436409841.7
2DLD Change Limit16460734019.0638634.9
3Display Results3403400.2031674.9
 (SQL Overall)17869134019.7029069.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.