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

54 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
pyrenoid144687(None) 
pyranoid1447281pyranoid
pyrenoids1544801pyrenoids
hyenoid1448612hy_enoid
paranoid11311142paranoid
pyroxenoid2353002pyroxenoid
adenoid959253_adenoid
arytenoid1353373arytenoid
catenoid1149113catenoid
coronoid1148943coronoid
crinoid1039943_crinoid
ctenoid1078683_ctenoid
cyprinoid1753463cyprinoid
glenoid937803_glenoid
gynecoid1543933gynecoid
hypnoid1647883hy_pnoid
hyracoid1745973hyracoid
myceloid1644853myceloid
myeloid13108123my_eloid
paranoia10410563paranoia
paranoic1249833paranoic
paranoids1248913paranoids
parented11912213parented
parotoid11410033parotoid
percoid12312313per_coid
pernod9310453per_no_d
phrenic1438773phren_ic
phrensied1543373phrensied
prebid113512843p_re_bid
preboil1148953p_reboil
preload1049813p_reload
premold1247863p_remold
prenoon9310043p_renoon
prepaid12310133p_repaid
presold1059603p_resold
pretold1049083p_retold
pygmoid1644533py_gmoid
pyoid11513763py___oid
pyralid1347983pyr_alid
pyramid1547513pyr_amid
pyranose1344923pyranose
pyranoside1653143pyranoside
pyrene113210733pyren__e
pyrenes123511223pyren_es
pyrethroid1963423pyrethroid
pyretic143210783pyre_tic
pyrexia19225463pyre_xia
pyrexic21235353pyre_xic
pyroxenoids2451943pyroxenoids
solenoid947873solenoid
sphenoid1446323sphenoid
terpenoid1244603terpenoid
thyreoid1544773thyre_oid
trendoid1045453_trendoid

Search took 15 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.420425454.8
2DLD Change Limit1461625414.20610288.8
3Display Results54540.060900.0
 (SQL Overall)1786915414.68612167.4
 
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.