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

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

42 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
antihysterics216209(None) 
antihysteric2062371antihysteric_
antihistorical1972524antihistorical
antipyretics19143974antipy_retics
antistories1149384anti__stories
hysterics1746054____hysterics
antherids1368725ant_h___erids
antibacterial1763155antibacterial
antibacterials1872415antibacterials
antibiotics1554895antibiot__ics
antibusers1244425antibus_er__s
antiemetics1586125anti__emetics
antihelices1655445antih___elices
antiheroes1347175antih___eroes
antiheroic1556385antih___eroic_
antiherpes1545405antih___erpes
antihistamine18102385antihistamine
antihistamines19122035antihistamines
antihistaminics2281035antihistaminics
antihunter1353865antihunter___
antilittering1462155antilittering
antimatters1354335antimatter__s
antimeric13410415anti___meric_
antimitotics1653775anti_mitotics
antimusics1445535antimus___ics
antipyics1645655antipy____ics
antipyretic18144725antipy_retic_
antiseptics1555415anti__septics
antiserums1254445anti__s_erums
antistatic1249045anti__static_
antistick1548445anti__st__ick
antistress1045755anti__st_ress
antistrike1455285anti__st_rike
antisymmetric2262655antisymmetric_
antitrusters1252015antitruster__s
artistries1047265arti__st_ries
autistics1147005auti__st__ics
baptisteries1652405bapti__steries
hysterias1547155____hysterias
hysteric1647535____hysteric_
nonhysterical2162655_nonhysterical
unhysterical2061845un__hysterical

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.390458182.1
2DLD Change Limit124790428.68614366.8
3Display Results42420.0331272.7
 (SQL Overall)178691429.10919617.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.