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

106 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
peracids1331007(None) 
peracid12312991peracid_
percoids1339662percoids
peroxids1837452peroxids
piracies12312642piracies
pyralids1445812pyralids
pyramids1645642pyramids
tetracids1245932tetracids
acids87121003___acids
antacids1148333antacids
aramids102810513_aramids
braids95015693_bra_ids
carabids1338193carabids
ceramics1446803ceramics
ceramide1347973ceramide
ceramides1447453ceramides
ceratins102818733ceratins
cercis104614493cer_ci_s
characids1745263characids
coracoids1445833coracoids
curacies12311763curacies
derails84216393dera_ils
dermoids1246163dermoids
diacids1137863_diacids
elapids1036503_elapids
feracity1646733feracity
heralds1137713hera_lds
hydracids1943843hydracids
hyperacid2046603hyperacid_
hyracoids1844253hyracoids
jerids142810943jer__ids
jerrids15277743jer_rids
keramics1644823keramics
keratins122313483keratins
legacies1139043legacies
mercies113817563mer_cies
mermaids1355753mermaids
monacids13137513monacids
nereids838743ner_eids
nonacids11148263nonacids
operands1146813opera_nds
operatics1346953operatics
oxyacids2162103oxyacids
papacies1439473papacies
paranoids1248913paranoids
parotids112610413parotids
peaced115818913pe_aced_
peaces106324083pe_ac_es
peaches144120053pe_aches
peacing124117073pe_acing
peascods1344063peascods
peavies122213403pe_avies
pelagics1345553pelagics
pencils113011773pe_ncils
penicils1247863penicils
peptids12239323pe_ptids
percales12313803percales
perches143717953per_ches
percoid12312313percoid_
percuss1137163per_cuss
perfidy1635273per_fidy
perils84121853per__ils
periodids1345643periodids
periods10312243per_iods
peris75537073per__i_s
periwigs1444193periwigs
permits11314003per_mits
pernods1038483per_nods
peroxid17310273peroxid_
peroxide1848183peroxide
peroxides1947493peroxides
perpends13227753perpends
perries93226603per_ries
pertains102113423pertains
petards104311153peta_rds
placid114012543p_lacid_
placoids1347343p_lacoids
plaids94312443p_la_ids
praxis154012253p_raxi_s
preaches153214893preaches
preacts113211363preac_ts
prebids12399883p_rebids
precis103416703p_reci_s
prelacies13310053prelacies
prescinds1444953prescinds
psocids1234863p_socids
pyralid1347983pyralid_
pyramid1547513pyramid_
raids65827513__ra_ids
ranids75118703__ranids
rapids94913893__rapids
reracks132310533rerac_ks
seracs84418573serac__s
serails73318363sera_ils
serais64326133sera_i_s
sericins10312463sericins
serranids1045533serranids
spermatids1545573spermatids
terais64023513tera_i_s
tetracid1147263tetracid_
triacids1146723triacids
upbraids1343553upbra_ids
uracils939373_uracils
veracious1447123veracious
veracity1647553veracity
verbids13259203ver_bids

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621068.93616356.5
3Display Results1061060.0462304.3
 (SQL Overall)1786911069.40518999.6
 
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.