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

45 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
antimonic1341008(None) 
anionic9312872an_i_onic
antigenic1249252antigenic
antimeric13410412antimeric
antimonial1248392antimonial
antimonide1356192antimonide
antimonies12410582antimonies
antimony1358302antimon_y
antimonyl1464772antimonyl
antimusic1346262antimusic
antinomic1348502antinomic
antitoxic18127202antitoxic
actinic111810553acti__nic
ammonic1349163a__mmonic
amnionic1245603amni_onic
anhedonic1543383anhedonic
animalic1258153an_imalic
anthropic1648423anthropic
antibiotic1456623antibiotic
anticivic1645563anticivic
antidromic1554723antidromic
antiemetic1498263antiemetic
antierotic1248623antierotic
antiman9313883antiman__
antimine10714753antimin_e
antimitotic1554753antimitotic
antimonials1356903antimonials
antimonides1455663antimonides
antimonyls1584223antimonyls
antimusics1445533antimusics
antimycin1646163antimycin
antipoetic1448223antipoetic
antipolice1456643antipolice
antipyic1546543anti_pyic
antitoxin16117493antitoxin
antitypic1644443antitypic
antivenin1247023antivenin
atonic83420473a_t__onic
avionic1237693a_vi_onic
cationic12310013cati_onic
daimonic1346603_daimonic
gnomonic1345903gn_omonic
mnemonic1445233mn_emonic
pneumonic1544253pneumonic
unironic1046053un_ironic

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641457.12320867.8
3Display Results45450.0162812.5
 (SQL Overall)178691457.56223630.1
 
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.