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

52 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
pyroxene204508(None) 
pyroxenes2145451pyroxenes
propene112716042p_ropene
pyrene113210732pyr__ene
pyrogen1337352pyrogen_
pyrogens1437292pyrogens
pyrone112714472pyro__ne
pyronine1349512pyronine
pyroxenic2345452pyroxenic
pyroxenite2254102pyroxenite
carotene1039133carotene
cymogene1644723cymogene
gyrene10227243gyr__ene
hypogene1746943hypogene
kerosene1254823kerosene
lycopene1544133lycopene
parolee94119643parole_e
peroxide1848183peroxide
pirogen1038263pirogen_
pliocene1244593pliocene
profane122111863p_rofane
progeny1389463p_rogeny
proline92321593p_roline
promine112819443p_romine
prone75332623p_ro__ne
propane112716153p_ropane
propend123311273p_ropend
propenes122816513p_ropenes
propense122410103p_ropense
propine113020213p_ropine
propone112716303p_ropone
protege1059153p_rotege
protend104012793p_rotend
proven114314773p_roven_
pyrenes123511223pyr__enes
pyrexes19305843pyrexe_s
pyridine1447743pyridine
pyridoxine2352333pyridoxine
pyrogenic1748923pyrogenic
pyrolize2248133pyrolize
pyrolyze2554143pyrolyze
pyrometer1648883pyrometer
pyrones123113303pyrone_s
pyronines1458323pyronines
pyrope132810533pyro__pe
pyropes142210193pyrope_s
pyroxenites2353823pyroxenites
pyroxenoid2353003pyroxenoid
thyroxine2243913thyroxine
tyrosine1147043tyrosine
zygotene2142523zygotene
zymogene2343743zymogene

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.406440125.6
2DLD Change Limit146162526.70321805.5
3Display Results52520.0134000.0
 (SQL Overall)178691527.12225090.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.