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

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

59 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
antacids114833(None) 
antacid10311221antacid_
autacoids1244772autacoids
abbacies1445483abbacies
acacias11510403a_cacias
acarids105312243a_carids
acetamids1443443acetamids
acids87121003___acids
agamids11317013a_gamids
alcids94812293a__lcids
androids1047753androids
aneroids9310203aneroids
angarias9310553angarias
angaries9314393angaries
animacies1348593animacies
anlaces92313733anlac_es
annelids946233annelids
antalgics1245173antalgics
antas55432033anta___s
antecede1145033antecede
antecedes1245063antecedes
antherids1368723antherids
anthoid11313313anthoid_
antiarins9413893antiarins
antibias10312083antibias
anticity13313603anticity
anticks134612253antic_ks
antics84621453ant__ics
antis55033313ant__i_s
aramids102810513a_ramids
ascarids11438503ascarids
astasias8410143astasias
ataxias14189343a_taxias
ataxics16196643a_taxics
ataxies142410013a_taxies
attaches13137723attaches
attacks13126943attac_ks
attains7310983atta_ins
autacoid1146253autacoid_
autocoids1246093autocoids
diacids1137863_diacids
entails7912823enta_ils
entasias8269143entasias
entasis73012573entasi_s
fantails1139693fanta_ils
fantasias1286993fantasias
fantasies1298853fantasies
invalids1244743invalids
mantids103113623mant__ids
monacids13137513monacids
monoacids14145793monoacids
navaids1134803nava_ids
niacins938543_niacins
nonacids11148263nonacids
oxyacids2162103oxyacids
peracids13310073peracids
tetracids1245933tetracids
triacids1146723triacids
untacks1357503untac_ks

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit146162597.73618893.7
3Display Results59590.0301966.7
 (SQL Overall)178691598.18921820.9
 
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.