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

36 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
antihistaminic217135(None) 
antihistaminics2281031antihistaminics
antihistamine18102382antihistamin_e
antihistamines19122032antihistamines
antivitamin1653714antivi_tamin__
antivitamins1763674antivi_tamin_s
antihistorical1972525antihistorical
antihysteric2062365antihyst__eric
antistatic1249045ant__ista__tic
activistic1744926activist____ic
amphisbaenic2371086a_mphisba_enic
animistic1367426an_imist____ic
annihilating1653086annihi_latin_g
anthelmintic1962406ant_h__elmintic
anthracitic1854016ant_h__racitic
antiarthritic1862616anti_arthritic
antibiotic1456626antibiot____ic
anticipating1756266antici_patin_g
antidiabetic1762886antidi__abetic
antifoaming1754116ant__ifoamin_g
antihumanistic2171786antih_umanistic
antihunting1573936antihunt__in_g
antihysterics2162086antihysteri_cs
antilittering1462156antilitterin_g
antimetabolic1972006anti_metabolic
antimitotic1554756antimi_t__otic
antimonic13410086ant__i___monic
antiparasitic1763236anti_parasitic
antispasmodic20121386ant__ispasmodic
antistrophic1974096ant__istrophic
histamin1387046____histamin__
histamine1476906____histamin_e
histamines1575896____histamines
histamins1476726____histamin_s
nativistic1555006nativist____ic
vitaminic1642226____vi_taminic

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.406440125.6
2DLD Change Limit124790369.48313159.3
3Display Results36360.0331090.9
 (SQL Overall)178691369.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.