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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
phytonic184820(None) 
photonic15312101photonic
peptonic1448832peptonic
phonic133315212ph__onic
photonics1649352photonics
photopic17411092photopic
phytoid1678752phyto_id
phyton143610252phyton__
phytons15319062phyton_s
platonic1238772platonic
plutonic1246102plutonic
protonic12314592protonic
pythonic1847552p_ythonic
acetonic1238733acetonic
aphonic142713393aph__onic
atonic83420473__atonic
chronic14311423ch_ronic
chthonic1846183chthonic
cratonic1239123cratonic
cryonic1437833cry_onic
daltonic1146523daltonic
diatonic1138683diatonic
dystonic1446513dystonic
glyconic1644613glyconic
hedonic1339043_hedonic
hyaenic1545993_hyaenic
hydronic1748093_hydronic
hyenic1438723_hy_enic
hypnic1637263_hy_pnic
hypotonic1948193_hypotonic
hypoxic2466283_hypoxic
isotonic10158323isotonic
ketonic1349923_ketonic
lactonic1248043lactonic
leptonic1247703leptonic
myotonic1547753myotonic
nektonic1445723nektonic
nontonic10410153nontonic
oxytocic2242263oxytocic
parsonic1239703parsonic
pentomic1448143pentomic
pharaonic1645763pharaonic
phatic133014413phat__ic
phelonia1347043phelonia
phenolic1546813phenolic
phimotic1747153phimotic
phobic153010073ph__obic
phonics143110723ph__onics
phoronid1449073phoronid
photic133316443ph__otic
photogenic1848293photogenic
photoing1439073photoing
photon1111514833photon__
photons123814433photon_s
photopia1549733photopia
phrenic1438773ph_renic
phyletic1847213phyletic
phylic16279553phy__lic
phyllomic2143383phyllomic
phylon14318033phylon__
physic16288473phy__sic
phytane1545443phytan_e
phytanes1645763phytanes
phytin14459013phyt__in
phytins15317893phytin_s
phytol14366563phyto__l
phytolith2064703phytolith
phytols15276553phyto_ls
phytotoxic2754623phytotoxic
pionic103515953p__ionic
platinic1237073platinic
pleonic1139433p_leonic
ptotic102713373p__totic
pulmonic1445033pulmonic
pyknic1734893p_y_knic
pyloric1438063p_yloric
rhetoric1345663rhetoric
rhythmic2143393rhythmic
rhyton12356113rhyton__
rhytons13295883rhyton_s
subtonic1246923subtonic
syntonic1347703syntonic
tectonic1248453tectonic
thionic1238893th_ionic
tonic74727653___tonic
tyronic1239313_tyronic
yonic105920843__y_onic

Search took 8 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.403443402.0
2DLD Change Limit146162876.80021494.4
3Display Results87870.0302900.0
 (SQL Overall)178691877.23324705.0
 
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.