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

137 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
protonic1231459(None) 
photonic15312101photonic
cratonic1239112cratonic
isotonic10158322isotonic
myotonic1547752myotonic
peptonic1448832peptonic
photonics1649352photonics
photopic17411092photopic
phytonic1848202phytonic
platonic1238772platonic
plutonic1246102plutonic
prosodic1347692prosodic
protatic12314742protatic
proteinic1346882proteinic
proteomic1546742proteomic
proton84318892proton__
protons93118002proton_s
protoxid1849142protoxid
protozoic2246152protozoic
acetonic1238733acetonic
aprotic112715243aprot__ic
atonic83420473__atonic
boronic11311163_boronic
bosonic1139213_bosonic
botanic1159583_botanic
colonic115015713_colonic
croton84415453croton__
crotons93714373croton_s
cryonic1437833cr_yonic
daltonic1146513daltonic
diatonic1138673diatonic
draconic1346193draconic
dystonic1446513dystonic
erogenic111110543erogenic
erotic82620273erot__ic
erotogenic1345023erotogenic
exotoxic1645153exotoxic
geoponic1347213geoponic
gnomonic1345903gnomonic
hormonic1568153hormonic
hypotonic1948193hypotonic
ironic8313773ir__onic
isogonic11187253isogonic
isotopic12187293isotopic
ketonic1349923_ketonic
krooni10397183kro_oni_
lactonic1248043lactonic
leptonic1247703leptonic
monotonic1348583monotonic
moronic11311863_moronic
motoric11312223_motoric
myotonia1346273myotonia
nektonic1445723nektonic
neotenic1047823neotenic
nontonic10410153nontonic
orogenic11109363orogenic
ototoxic1744973ototoxic
ovonic11288183__ovonic
ozonic17308943__ozonic
parotic112518043parot__ic
parotitic1349333parotitic
parotoid11410033paroto_id
parsonic1239703parsonic
pentomic1448143pentomic
phonic133315213p__honic
phoronid1449073phoronid
photic133316443phot__ic
photogenic1848293photogenic
photoing1439073photoing
photon1111514833photon__
photons123814433photon_s
photopia1549733photopia
pionic103515953p__ionic
platinic1237073platinic
pleonic1139433p_leonic
pogonia1048933p_ogonia
pogonip1245373p_ogonip
potamic13310853p_otamic
preatomic1546023preatomic
probiotic1546663probiotic
prodromic1644563prodromic
prolific1546743prolific
prolong10319633prolon_g
prolonge11388403prolonge
prolongs11347613prolongs
promoing13310463promoing
propolis12311403propolis
propone112716303propon_e
proponed132412033proponed
propones122516963propones
proponing1439993proponing
proptosis1348203proptosis
propylic1747183propylic
prosaic11311163pro_saic
prostatic13410853prostatic
prostomia1347523prostomia
protamin121210543protamin
protasis102411973protasis
protei82615313prot_ei_
proteid103513673prot_eid
protein92414733prot_ein
proteins102114283proteins
protend104012793proten_d
protends113010353protends
prothetic161010073prothetic
protistic13410983protistic
protocol1246473protocol
protonate11412573protonate
protonema1345413protonema
protopod1347353protopod
prototypic1954773prototypic
protoxide1946823protoxide
protoxids1947183protoxids
protozoa1945423protozoa
proxemic2146153proxemic
ptotic102713373p__totic
pulmonic1445033pulmonic
puritanic1343583puritanic
pyogenic1648583pyogenic
pyrogenic1748923pyrogenic
pyroxenic2345453pyroxenic
pythonic1847553pythonic
robotic1139223_robotic
scotopic1446513scotopic
serotonin947373serotonin
sporogonic1553543sporogonic
stolonic1047583stolonic
subtonic1246923subtonic
syntonic1347703syntonic
tectonic1248453tectonic
tonic74727653___tonic
tortoni738033tortoni_
tortonis848743tortonis
troponin1047943troponin
urologic1147343urologic
vagotonic1543683vagotonic
zootomic2145423zootomic

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.423422437.4
2DLD Change Limit1461621377.79618748.3
3Display Results1371370.0462978.3
 (SQL Overall)1786911378.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.