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

94 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
pyronine134951(None) 
pyronines1458321pyronines
pavonine1346662pavonine
proline92321592p_roline
promine112819442p_romine
propine113020212p_ropine
pyridine1447742pyridine
pyrolize2248132pyrolize
pyrone112714472pyro__ne
pyroxene2045082pyroxene
tyrosine1147042tyrosine
aproning11311793aproning
atropine10410113atropine
baronne938263baron_ne
bromine112915243_bromine
byrnie11348573byr_ni_e
conine84528553__conine
crocine11314153_crocine
cyanine122911513cy_anine
cytokine1745023cytokine
cytosine1346873cytosine
droning93013723_droning
heroine103517483hero_ine
hyenine1336953hy_enine
ironing82414013_ironing
ironize16610373_ironize
kerosine1238143kerosine
leonine7311233_leonine
mylonite1346813mylonite
pardine103616723par_dine
pardoning1338763pardoning
paroling113316213paroling
parvoline1477173parvoline
patronise1198443patronise
patronize2077193patronize
pemoline12310273pemoline
pennine93712953p_ennine
peroxide1848173peroxide
phocine1438833p_hocine
phoning13312053p_honing
picoline12310853picoline
pontine92419053p__ontine
porcine11312843por_cine
praline93019743p_raline
primine113214823p_rimine
probing123314443p_robing
procaine12312273p_rocaine
profane122111863p_rofane
profile123211153p_rofile
prolines102619693p_rolines
promines123018803p_romines
promise113415843p_romise
pronate9418873p_ronate
prone75332623p_ro__ne
pronging123511843p_ronging
propane112716153p_ropane
propene112716043p_ropene
propined133111503p_ropined
propines122618933p_ropines
propone112716303p_ropone
prosing103319383p_rosing
provide1339853p_rovide
province1546923p_rovince
proving134214073p_roving
pruning10311733p_runing
purine85321893pur__ine
purline93516533pur_line
pyranose1344923pyranose
pyrene113210733pyr__ene
pyridines1546473pyridines
pyridoxine2352333pyridoxine
pyrite11913313pyr__ite
pyrogen1337353pyrogen_
pyrogens1437293pyrogens
pyrolized2446113pyrolized
pyrolizes2347233pyrolizes
pyrolyze2554143pyrolyze
pyrones123113303pyron_es
pyrope132810533pyro__pe
pyrosis12411653pyrosi_s
pyrosises1457583pyrosises
pyroxenes2145453pyroxenes
pyroxenite2254103pyroxenite
saponine1039223saponine
serotine8313573serotine
thionine1187923thionine
threonine1245103threonine
throning1238863throning
thyroxine2243913thyroxine
tropine93116653_tropine
tyramine1347303tyramine
tyronic1239313tyroni_c
tyrosines1246863tyrosines
vireonine1244563vireonine

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162946.56322270.6
3Display Results94940.0462043.5
 (SQL Overall)178691946.76526414.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.