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

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

57 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
flavonoids175160(None) 
flavonoid1651971flavonoid_
flavonols1542182flavono_ls
falconoid1553153falconoid_
flavanols1542203flavano_ls
flavanones1652063flavanones
flavones1435833flavon__es
flavonol1442213flavono__l
flavorous1544253flavoro_us
platinoids1344003platinoids
salmonoids1352763salmonoids
adenoids1056864__adenoids
ammonoids1493524_ammonoids
arachnoids1663374arachnoids
avoids104410204__av__oids
blazonries2153124blazonries
braconids1444194bracon_ids
catenoids1246434_catenoids
conoids10813884___conoids
factoids1446244f_a_ctoids
falconries1543944falconries
favonian1442974f_avon_ian
fibrinoids1652444fibrinoids
flacons1238054flacon___s
flagons1137974flagon___s
flavanol1442404flavano__l
flavanone1552014flavano_ne
flavines1437894flavin__es
flavins1338544flav___ins
flavone1335524flavon___e
flavored1554574flavo_red_
flavorers1563984flavo_rers
flavoring1665114flavo_ring
flavorings1762974flavorings
flavorist1545454flavo_rist
flavorists1643524flavorists
flavorless1642184flavorless
flavors1337294flav__o_rs
flavoured1642974flavoured_
flavouring1743004flavouring
flavours1434694flav__ours
floods104511654fl__o_o_ds
fluorids1245494fl_uo_rids
ganoids939334_ga__noids
globoids1244414gl__oboids
glonoins955844gl__onoins
labroids1155844_la_broids
melanoids1245554mela__noids
paranoids1248914_paranoids
parotoids1256954_parotoids
placoids1347344pla__coids
plafonds1443274plafon__ds
planetoids1344094planetoids
plasmoids1444544pla_smoids
platinoid1244864platinoid_
salmonids1245544salmon_ids
salmonoid1243884salmonoid_

Search took 10 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 Filter1786911614500.1731032896.0
2DLD Change Limit161450579.71616616.9
3Display Results57570.0331727.3
 (SQL Overall)178691579.92218009.6
 
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.