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

147 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
peroxid1731028(None) 
peroxide1848191peroxide
peroxids1837451peroxids
parotid102915512parotid
peracid12312992peracid
percoid12312322percoid
periodid1248162periodid
peroxided2045082peroxided
peroxides1947492peroxides
peroxidic2144472peroxidic
peroxy1838252perox_y
tetroxid1646452tetroxid
xeroxed14244532xeroxed
aerobia939473aerobia
aerobic11310213aerobic
aneroid8314013anero_id
aroid65428343_aro_id
berobed1238243berobed
bromid112612893_bromid
carotid102014833carotid
ceboid11310653cebo_id
cerotic11415063cerotic
cervid1239323cer_vid
dermoid1138523dermoid
detoxed1636103detoxed
devoid1189363devo_id
dioxid1568393_dioxid
droid74218543_dro_id
emeroid101511183emero_id
epoxide1745343_epoxide
epoxied1734823_epoxied
eroded84313593_eroded
erotic82620273_erotic
fervid1337513fer_vid
geoid74215763ge_o_id
hemoid12313513hemo_id
heroic113516923hero_ic
heroin94420593hero_in
jerid132316423jer__id
jerrid14259143jer_rid
keloid11812623kelo_id
leporid1048153leporid
meloid9616003melo_id
mermaid1297853mermaid
meropia1149623meropia
meropic13310273meropic
negroid9108903negro_id
nereid7312933ner_eid
neroli61111163neroli_
nerolis71012783nerolis
neuroid81110313neuro_id
nevoid1098803nevo_id
oxid12815493___oxid
parodic122311723parodic
parodied1238343parodied
paroled104217633paroled
parotic112518043parotic
parotids112610413parotids
parotoid11410033parotoid
peloria9310953peloria
peloric11310713peloric
pentoxide1944183pentoxide
peponida1345183peponida
peptid112712373pe_ptid
peracids13310073peracids
perched154713243perched
percoids1339663percoids
perdie94718513per_die
pereia85217983per_eia
pereopod1344933pereopod
perfidy1635273per_fidy
peri65636973per__i_
peridia10312373peridia
peril75425953per__il
periled10316323periled
period9314983per_iod
periodic1348433periodic
periodids1345643periodids
periotic12313443periotic
peris75537073per__is
periti8319953periti_
periwig1345163periwig
perked134617693per_ked
permed115217353per_med
permit10321683per_mit
pernio8513143per_nio
pernod9310453per_nod
peroral9314793peroral
peroxidase2053193peroxidase
peroxiding2144933peroxiding
perpend12259353perpend
pertain92714963pertain
peruked14367893peruked
perused103112203perused
petrolic1249693petrolic
phenoxide2244093phenoxide
phoronid1449073phoronid
pierogi1054723pierogi_
pirogi9299013pirogi_
poxed154817863p__oxed
praxis154012253p_raxis
prebid113512843p_rebid
prepaid12310133prepaid
probed114114823p_robed
probit103218353p_robit
prod76129503p_ro__d
profit113016273p_rofit
prolix1538683p_rolix
prosed94921103p_rosed
prosit85124593p_rosit
proteid103513673p_roteid
protoxid1849143protoxid
proud84615483p_ro_ud
proved125016033p_roved
provide1339853p_rovide
proxies163014933p_roxies
proximo1845143p_roximo
proxy175011013p_rox_y
psocid1137253p_socid
pteropod1344663pteropod
pyoid11513763p_yo_id
pyralid1347983pyralid
pyramid1547513pyramid
pyrexia19225463pyrexia
pyrexic21235353pyrexic
pyrosis12411653pyrosis
remorid10311863remorid
sparoid102311543sparo_id
spheroid1447283sphero_id
spiroid10219823spiro_id
sporoid102310733sporo_id
steroid81314873stero_id
superoxide2045813superoxide
tetroxide1744293tetroxide
tetroxids1744283tetroxids
theroid11313403thero_id
toroid7416013toro_id
trioxid1546613trioxid
verbid122311313ver_bid
viroid10411523viro_id
xerosis14249673xerosis
xerotic16410863xerotic
xerox1138623xerox__
xeroxes13246443xeroxes
xeroxing1534513xeroxing
zebroid1936473zebro_id
zeroed16409423zero_ed

Search took 7 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.436409841.7
2DLD Change Limit1340271476.37621020.5
3Display Results1471470.0632333.3
 (SQL Overall)1786911476.87525991.4
 
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.