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

55 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
agonistic124668(None) 
aconitic1239532aconi_tic
agnostic1146712ag_nostic
agonist82615402agonist__
agonistes10266262agonistes
agonists9289832agonist_s
amoristic1347992amoristic
aoristic10311162a_oristic
atomistic1347772atomistic
egoistic1147102ego_istic
egotistic1246132egotistic
jargonistic2153102jargonistic
monistic12311302_monistic
acoustic1246443aco_ustic
agenetic1138203agen_etic
agnatic10310973ag_n_atic
agnostics1244463ag_nostics
agonic93515143agon___ic
agonise83112693agonis__e
agonised10248483agonis_ed
agonises92613163agonis_es
agonising1146573agonising
agrestic1147923ag_restic
albinistic1454013albinistic
ammonitic1545313ammoni_tic
amnestic1247053a_mnestic
amniotic1246403a_mniotic
animistic1367423animistic
anisic8313793a__nis_ic
antagonistic1553183antagonistic
aphoristic1746363aphoristic
apodictic1644373apodictic
apomictic1744183apomictic
aragonitic1354203aragoni_tic
artistic10310893a_rtistic
atavistic1445983atavistic
atheistic1447353atheistic
autistic10310103a_utistic
faunistic1444473faunistic
floristic1447163floristic
gnostic1038433_g_nostic
gonidic1166103_goni_dic
hedonistic1644543hedonistic
holistic13311263_holistic
logistic1147823_logistic
monastic1249863_monastic
nomistic1279593_nomistic
onanistic1147373onanistic
parodistic1546803parodistic
pianistic1347173pianistic
protistic13410983protistic
rigoristic1354233rigoristic
tropistic1347223tropistic
utopistic1345383utopistic
wholistic1745943wholistic

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.406440125.6
2DLD Change Limit148641557.26620457.1
3Display Results55550.0301833.3
 (SQL Overall)178691557.70223200.6
 
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.