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

31 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
antipyretics1914397(None) 
antipyretic18144721antipyretic_
antiemetics1586123anti_emetics
antiparties1347563antipar_ties
antipoetic1448223antip_oetic_
antipolitics1655803antipolitics
antipruritics17132913antipruritics
antipyics1645653antipy___ics
anoretics1148644an___oretics
antibiotics1554894anti_biotics
antiemetic1498264anti_emetic_
antiepileptics20121984antiepileptics
antierotic1248624anti_erotic_
antihysterics2162084antihysterics
antimitotics1653774antimitotics
antiparticle1663044antipar_ticle
antiparticles1762384antipar_ticles
antipathetic1963834antipathetic_
antiphrasis1655384antiphrasi_s
antipress1146414antip_re__ss
antiprotons1353844antip_rotons
antipruritic1693524antipruritic_
antipsychotics26141644antipsychotics
antipyic1546544antipy___ic_
antipyrine1555504antipyr__ine
antipyrines1654744antipyr_ines
antiseptics1555414anti_septics
antithetic1547404anti_thetic_
apyretic1546844a___pyretic_
entireties1047274enti__reties
natriuretics1471094natriuretics

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 Limit124790318.65614416.6
3Display Results31310.0301033.3
 (SQL Overall)178691319.07919681.8
 
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.