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

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
antidotally155352(None) 
anecdotally1751922anecdotally
antidotal1046132antidota_l_
antenatally1453043antenatally
antically14315683anti__cally
antiphonally2052833antiphonally
antisocially1754003antisocially
nationally1348423nati_onally
accidentally2062734accidentally
actinally1448234acti__nally
actinically1847084actinically
actionably17105514acti_onably
anecdotal12182574anecdota_l_
anecdotically2164624anecdotically
animally1368644an_i__mally
anodally1246294an___odally
anodically1648264an_odically
antibiotically2163454antibiotically
antidora947874antidora___
antidote949724antidot___e
antidoted1146724antidot__ed
antidotes1049534antidot__es
antidoting1247164antidot_ing
antidromically2262664antidromically
antinodal1046324antinoda_l_
antipodal1246354antipoda_l_
antipodals1355334antipoda_ls
antiroll847764antiro__ll_
antiroyal1246014antiroya_l_
atonally1148634a_t__onally
autosomally1652164autosomally
factionally1946394facti_onally
incidentally1854124incidentally
notionally1347084noti_onally
ontically14311844onti__cally
optionally1545944opti_onally
pivotally1743644__pivotally
rationally1349424rati_onally
sacerdotally1861474sacerdotally
tidally1137934__tid__ally
totally1039894__t__otally
univocally1852994un_ivocally

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 Filter1786911488190.423422437.4
2DLD Change Limit148819428.56317379.3
3Display Results42420.0301400.0
 (SQL Overall)178691429.01619819.3
 
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.