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

165 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
thionic123889(None) 
thiolic1247321thiolic
thionin1048671thionin
anionic9312872anionic
avionic1237692avionic
bionic103614572_bionic
chronic14311422chronic
ionic74622662__ionic
phonic133315212ph_onic
pionic103515952_pionic
thionine1187922thionine
thionins1177922thionins
thionyl1343712thionyl
thoric114314042th_oric
tonic74727652t__onic
tyronic1239312tyronic
abiotic11510463abiotic
acinic104713543aci_nic
acronic112814693acronic
aeonic83517043_aeonic
agonic93515143_agonic
aminic104413513ami_nic
ammonic1349163ammonic
amnionic1245603amnionic
aphonic142713393aphonic
atonic83420473_atonic
avionics1344953avionics
axonic154312723_axonic
azonic175513153_azonic
bionics114310873_bionics
biontic1148333_biontic
biopic123710673_biopic
biotic103816613_biotic
boronic11311163boronic
bosonic1139213bosonic
bubonic1366243bubonic
canonic11312933canonic
cationic12310013cationic
chaotic14310043chaotic
chloric143410613chloric
choric133515903ch_oric
chorionic1646493chorionic
chromic1639863chromic
chronics1538683chronics
chthonic1846183chthonic
clinic104312793cli_nic
clonic104914673_clonic
colonic115015713colonic
conic95329793__conic
cryonic1437833cryonic
daimonic1346603daimonic
demonic12311223demonic
epigonic1346723epigonic
ethion938813ethion__
ethionine1274863ethionine
ethions1038483ethion_s
ethnic1148853eth__nic
exonic153211413_exonic
hedonic1339043hedonic
hyenic1438723_hyenic
hypnic1637263_hypnic
iconic10411593_iconic
idiotic1037463idiotic
iodic84816753__iodic
ionics84214483__ionics
ironic8313773_ironic
kaonic1238763_kaonic
ketonic1349923ketonic
laconic1139883laconic
limnic10418843_limnic
masonic1139913masonic
meiotic11410933meiotic
mesonic11310093mesonic
miotic103715753_miotic
moronic11311863moronic
muonic10410183_muonic
niobic1037243_niobic
nonionic1049233nonionic
obconic1346353obconic
opsonic1137253opsonic
ovonic11288183_ovonic
ozonic17308943_ozonic
phimotic1747153phimotic
phobic153010073ph_obic
phonics143110723ph_onics
photic133316443ph_otic
photonic15312103photonic
phrenic1438773phrenic
phytonic1848203phytonic
pianic103714123_pianic
picnic123410263_picnic
pleonic1139433pleonic
pythonic1847553pyth_onic
quinic17319473qui_nic
rhizomic2442993rhizomic
rhodic12227233rh_odic
rhotic112711233rh_otic
sonic75225293__sonic
sthenic1268903sth_enic
stolonic1047583stolonic
tachyonic1943273tachyonic
tahini939893tahi_ni_
tahinis1048013tahi_nis
tannic82811473t_annic
technic1496903technic
tectonic1248453tectonic
telomic1147603telomic
telsonic1045993telsonic
tetanic9810133tetanic
thallic1246553thallic
theistic1348153theistic
theodicy1742773theodicy
theogonic1545543theogonic
thermic1439333thermic
thermionic1753493thermionic
thetic11412893th_etic
thiamin1236933thiamin
thiazin1945483thiazin
thin76732393thi_n__
thine85026863thi_n_e
thing96622983thi_n_g
things104914303thi_ngs
think125018803thi_n_k
thinks134613363thi_nks
thinly1238673thi_nly
thinned11399163thinned
thinner10358973thinner
thinning12319093thinning
thinnish1454873thinnish
thins85826333thi_n_s
thio77225413thio___
thiol87616043thio__l
thiols95112763thio_ls
thionate11137503thionate
thionines12106973thionines
thionyls1442943thionyls
thong95014183th_on_g
thongs104611193th_ongs
thoria93012893th_oria
throne98517603thron_e
throned115412173throned
thrones105715843thrones
throng10539973thron_g
throngs11508163throngs
throning1238863throning
thymic16307423th_ymic
titanic968553titanic
tonics83617863t__onics
toonie63617993t_oonie
topic95721503t__opic
toric76529313t__oric
toxic145315623t__oxic
triadic1037833triadic
trioxid1546613trioxid
tripodic1345333tripodic
trismic1137483trismic
trisomic1245943trisomic
tropic103014193t_ropic
tunic74018223t__unic
twoonie1034423twoonie
typhonic1847173typhonic
umbonic1365463umbonic
unironic1046053unironic
vinic10314973_vi_nic
yonic105920843__yonic

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271656.36021073.4
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.81326227.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.