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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
diatonic113868(None) 
diatomic1346971diatomic
atonic83420472__atonic
cratonic1239122cratonic
daimonic1346602daimonic
daltonic1146522daltonic
diabolic1345732diabolic
diactinic1443452diactinic
dialogic1247452dialogic
diastolic1244102diastolic
diatropic1445932diatropic
draconic1346202draconic
dystonic1446512dystonic
platonic1238772platonic
acetonic1238733acetonic
aeonic83517043__aeonic
agonic93515143__agonic
anatomic1258683anatomic
atomic104115603__atomic
atonia63816513__atonia
atonics93613713__atonics
atopic103514143__atopic
axonic154312723__axonic
azonic175513153__azonic
bionic103614573bi__onic
canonic11312933_canonic
catatonic1346103catatonic
cationic12310013_cationic
cistronic1345483cistronic
daemonic1356913daemonic
daturic1047043d_aturic
demonic12311223d_emonic
diabasic1345103diabasic
diabetic1346553diabetic
diachronic1853503diachronic
diacidic1444063diacidic
diaconal1196133diaconal
diagonal1095653diagonal
dialytic1446813dialytic
diamond1186113diamon_d
diamonds12125173diamonds
diapiric1344383diapiric
diarchic1645613diarchic
diasporic1444173diasporic
diastasic1244033diastasic
diastatic1245943diastatic
diathetic1546813diathetic
diatom939453diato__m
diatomite1246023diatomite
diatoms1039073diato_ms
diatron839283diatron__
diatrons939623diatron_s
diazonium2193593diazonium
dichotic1647663dichotic
dicrotic1348883dicrotic
dietetic1146803dietetic
digitonin11113383digitonin
diploic1247763diplo_ic
diplontic1444523diplontic
diplopic1545593diplopic
dipodic1397593di_podic
diprotic1348553diprotic
disomic1238763di_somic
dittoing1036263dittoing
dystonia1245473dystonia
gnathonic1543933gnathonic
historic1388943historic
iatric8312173_iat_ric
iconic10411593_i_conic
ionic74622663_i__onic
ironic8313773_i_ronic
isatinic1044463isatinic
isotonic10158323isotonic
kaonic1238763_ka_onic
ketonic1349923_ketonic
laconic1139883_laconic
lactonic1248053lactonic
leptonic1247703leptonic
litotic939243li_totic
masonic1139913_masonic
mitotic1139713mi_totic
myotonic1547753myotonic
nektonic1445723nektonic
nontonic10410153nontonic
peptonic1448833peptonic
photonic15312103photonic
phytonic1848203phytonic
pianic103714123pia__nic
pionic103515953pi__onic
platinic1237073platinic
plutonic1246103plutonic
protonic12314593protonic
rigatoni944623rigatoni_
rigatonis1044513rigatonis
satanic939933_satanic
siphonic1547983siphonic
subtonic1246923subtonic
syntonic1347703syntonic
tectonic1248453tectonic
titanic968553ti_tanic
tonic74727653___tonic
triatomic1344303triatomic
viatic11311453viat__ic
vibronic1545133vibronic
zirconic2144013zirconic

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621057.39319770.3
3Display Results1051050.0303500.0
 (SQL Overall)1786911057.85922737.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.