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

187 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
peracid1231299(None) 
peracids13310071peracids
hyperacid2046602hyperacid
peaced115818912pe_aced
percoid12312322percoid
peroxid17310282peroxid
placid114012542p_lacid
pyralid1347982pyralid
pyramid1547512pyramid
tetracid1147262tetracid
acid77533393___acid
aerated85322373aerated
afraid1049723afra_id
antacid10311223antacid
aramid93315613_aramid
belaced124112153belaced
beraked144312433beraked
berated104422133berated
boracic1338723boracic
braced115420603_braced
braid85822263_bra_id
carabid12311333carabid
ceramic1339823ceramic
ceramide1347973ceramide
cerated103922473cerated
ceratin93020163ceratin
ceratoid1149923ceratoid
cerci93716393cer_ci_
cercis104614493cer_cis
cervid1239323cer_vid
characid1646863characid
coracoid1348163coracoid
defaced142910973defaced
derail74218813dera_il
derated93623503derated
dermoid1138523dermoid
diacid10310633_diacid
elapid939543_elapid
erased74816763_erased
ericoid1049893_ericoid
feracity1646733feracity
fervid1337513fer_vid
graced105217903_graced
gravid113710983_gravid
herald10311343hera_ld
hydracid1844983hydracid
hyperarid1847073hyperarid
hyracoid1745973hyracoid
jerid132316423jer__id
jerrid14259143jer_rid
keramic1537233keramic
keratin113314153keratin
keratoid1347273keratoid
menaced122710093menaced
mermaid1297853mermaid
monacid121310243monacid
nereid7312933ner_eid
nonacid101210843nonacid
operand1038003opera_nd
operated11512223operated
operatic1249933operatic
oxyacid2062773oxyacid
paced106931683p__aced
paid75737483p__a_id
palaced124110783palaced
paraded114014263paraded
paranoid11311143paranoid
parotid102915513parotid
pavid115717003p__avid
peace95026083pe_ac_e
peaces106324083pe_aces
peach125422493pe_ac_h
peached154315883pe_ached
peachy164510843pe_achy
peacing124117073pe_acing
peaked136117403pe_aked
pealed95322813pe_aled
pearled10411553pearled
peascod1244073peascod
pedaled113711893pedaled
pelagic1237863pelagic
pellucid1343003pellucid
penanced1338163penanced
pencil103712973pe_ncil
penicil1138833penicil
peptid112712373pe_ptid
percale11314093percale
perch124518833per_c_h
perched154713243perched
percoids1339663percoids
perdie94718513per_die
pereia85217983per_eia
perfidy1635273per_fidy
peri65636973per__i_
peridia10312373peridia
peril75425953per__il
periled10316323periled
period9314983per_iod
periodid1248163periodid
peris75537073per__is
periti8319953periti_
periwig1345163periwig
perked134617693per_ked
permed115217353per_med
permit10321683per_mit
pernio8513143per_nio
pernod9310453per_nod
peroxide1848193peroxide
peroxids1837453peroxids
perpend12259353perpend
pertain92714963pertain
peruked14367893peruked
perused103112203perused
pervaded1535373pervaded
petaled103614153petaled
petaloid1148753petaloid
petard95013803peta_rd
phrased1387383phrased
pierced12347593pier_ced
piracies12312643piracies
piracy1339473pirac_y
pirated102515613pirated
piratic11314293piratic
placed114318003p_laced
placoid1239773p_lacoid
plaid85118303p_la_id
practic13312253p_ractic
pranced123714043p_ranced
prated94924923p_rated
praxis154012253p_raxis
prayed124815433p_rayed
preach133613923preac_h
preached163412063preached
preachy17307313preachy
preact103220393preac_t
preacted132710943preacted
preacts113211363preacts
preaged11612333preaged
prebid113512843p_rebid
precis103416703p_recis
prefaced1638423prefaced
prepaid12310133prepaid
prerace11414123prerac_e
preradio1145723preradio
prescind1338393prescind
priced115018883p_riced
psocid1137253p_socid
puranic11410483puranic
pyralids1445813pyralids
pyramids1645643pyramids
pyranoid1447283pyranoid
rabid84520783__rabid
raced87635313__raced
raid55243073__ra_id
rancid9513863__rancid
ranid66429333__ranid
rapid86422033__rapid
refaced133713573refaced
relaced103517213relaced
relaid75518443rela_id
repaid94716323repa_id
rerack122513163rerac_k
reracked15169123reracked
reracks132310533reracks
resaid74517083resa_id
retraced111413023retraced
sebacic1346393sebacic
serac75925203serac__
seracs84418573serac_s
serai56830163sera_i_
serail64222673sera_il
serais64326133sera_is
sericin9312843sericin
serranid947573serranid
spermatid1448043spermatid
subacid1248473subacid
terai53525483tera_i_
terais64023513tera_is
teratoid9411073teratoid
terraced11318123terraced
tetracids1245933tetracids
traced94821583_traced
triacid1038593triacid
upbraid1244973upbra_id
uracil8311543_uracil
veracity1647553veracity
verbid122311313ver_bid

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271877.65617506.1
3Display Results1871870.0632968.3
 (SQL Overall)1786911878.12222000.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.