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

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

38 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
pharmaceuticals26101401pharmaceuticals_
pharmaceutical25101862pharmaceutical__
nutraceuticals187915nutr_aceuticals_
hermeneutical2061316_hermeneutical__
hermeneutically2561806_hermeneutically
nutraceutical1771586nutr_aceutical__
paramedicals19142776p_ar_ame_dicals_
pharmacological2793546pharmacological__
pharmacopeial24172726pharmacopei_al__
pharmacopeias24172816pharmacopei_a_s_
practicals1645546p__r_ac__ticals_
therapeutically2561626ther_apeutically
hermeneutics1961497_hermeneutic__s_
hermetical1746387_herm__e_tical__
hermetically2248387_herm__e_tically
parabiotically2374127p_ar_abiotically
parachutic1954297p_ar_achutic____
parachutist1853427p_ar_achuti___st
parachutists1952417p_ar_achuti_sts_
paragenetically2362727p_ar_agenetically
paralytically2355257p_ar_a_lytically
paramedical18114407p_ar_ame_dical__
parametrically2354487p_ar_ametrically
parasitical1555657p_ar_a_sitical__
parasitically2056807p_ar_a_sitically
paratactical1852927p_ar_atactical__
paratactically2353527p_ar_atactically
pharmacies1945787pharmac___i__es_
pharmacist1975787pharmac___i___st
pharmacists2084177pharmac___i_sts_
pharmacopeia23173187pharmacopei____a
pharmacopoeial25172657pharmacopoeial__
pharmacopoeias25162737pharmacopoeia_s_
practical1548847p__r_ac__tical__
practically20410447p__r_ac__tically
pragmatical1854907pragma___tical__
pragmatically2356267pragma___tically
therapeutics1961407ther_apeutic__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 Filter178691950240.406440125.6
2DLD Change Limit95024389.42010087.5
3Display Results38380.0331151.5
 (SQL Overall)178691389.85918124.7
 
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.