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

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

34 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
polypropylenes23786(None) 
polypropylene2271011polypropylene_
polyethylenes2461384poly_ethylenes
propylenes1744374____propylenes
polyethylene2361505poly_ethylene_
polyphones2046965polypho____nes
polystyrenes2072095poly__styrenes
propylene1644455____propylene_
chloroprenes1973236chl_orop_renes
gyroplanes1644296__gy_rop_lanes
hydroplanes2055876__hydrop_lanes
lycopenes1644636__ly_cop__enes
polybutadienes2217916polybutadienes
polydactylies2491426polydactyl_ies
polyenes13510066pol_____y_enes
polygenes1557506pol_____ygenes
polygraphers2353406polygrap_he_rs
polylysines1952826poly___lysines
polyonymies2153456poly__ony_mies
polypeptides1952606polyp_ep_tides
polyphone1946616polypho____ne_
polyphonies2155366polypho___nies
polyphyletic2762226polyp__hyletic
polyploidies2072686polyplo__idies
polypodies1855996polyp_o___dies
polypores1648006polyp_o____res
polystyrene1962116poly__styrene_
polythenes1865466poly____thenes
polyurethanes2161296polyur_ethanes
polyvalences2271926poly___valences
propenes122816516____prop__enes
propylites1746306____propylites
pyroxenes2145456p__y_ro__xenes
pyroxylins2563456p__y_roxylin_s

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 Filter1786911247900.393454684.5
2DLD Change Limit124790349.40613267.1
3Display Results34340.0301133.3
 (SQL Overall)178691349.82918180.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.