Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “ionic” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

80 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
ionic	7	46	2266	(None)
bionic	10	36	1457	1	bionic
conic	9	53	2979	1	conic
iconic	10	4	1159	1	iconic
iodic	8	48	1675	1	iodic
ionics	8	42	1448	1	ionics
ironic	8	3	1377	1	ironic
pionic	10	35	1595	1	pionic
sonic	7	52	2529	1	sonic
tonic	7	47	2765	1	tonic
yonic	10	59	2084	1	yonic
aeonic	8	35	1704	2	aeonic
agonic	9	35	1514	2	agonic
amnic	9	55	1624	2	amnic
anionic	9	3	1287	2	anionic
atonic	8	34	2047	2	atonic
avionic	12	3	769	2	avionic
axonic	15	43	1272	2	axonic
azonic	17	55	1315	2	azonic
bionics	11	43	1087	2	bionics
biontic	11	4	833	2	biontic
biopic	12	37	1067	2	biopic
biotic	10	38	1661	2	biotic
boric	9	80	2422	2	boric
clonic	10	49	1467	2	clonic
colic	9	57	2617	2	colic
comic	11	47	2181	2	comic
coni	6	55	3480	2	coni_
conics	10	39	2059	2	conics
conin	7	62	3272	2	conin
cynic	12	47	1242	2	cynic
domic	10	43	1724	2	domic
exonic	15	32	1141	2	exonic
folic	10	53	1932	2	folic
genic	8	51	1939	2	genic
gonia	6	41	1753	2	gonia
gonif	9	43	2092	2	gonif
ictic	9	3	1180	2	ictic
inia	4	50	2470	2	i_nia
iodid	7	43	1553	2	iodid
iodin	6	44	1935	2	iodin
ion	3	60	5102	2	ion__
ionise	6	35	1694	2	ionise
ionium	8	6	1092	2	ionium
ionize	15	46	1387	2	ionize
ions	4	67	3785	2	ion_s
irenic	8	3	1110	2	irenic
kaonic	12	3	876	2	kaonic
limnic	10	41	884	2	limnic
logic	8	82	1783	2	logic
lotic	7	64	2067	2	lotic
manic	9	46	2944	2	manic
miotic	10	37	1575	2	miotic
monie	7	56	3165	2	monie
muonic	10	4	1018	2	muonic
niobic	10	3	724	2	niobic
odic	7	49	2057	2	_odic
ontic	7	44	1857	2	_ontic
otic	6	66	2482	2	_otic
ovonic	11	28	818	2	ovonic
ozonic	17	30	894	2	ozonic
panic	9	39	2390	2	panic
phonic	13	33	1521	2	phonic
pianic	10	37	1412	2	pianic
picnic	12	34	1026	2	picnic
runic	7	36	1577	2	runic
sodic	8	49	1749	2	sodic
sonics	8	43	1563	2	sonics
thionic	12	3	889	2	thionic
tonics	8	36	1786	2	tonics
topic	9	57	2150	2	topic
toric	7	65	2931	2	toric
toxic	14	53	1562	2	toxic
tunic	7	40	1822	2	tunic
vinic	10	3	1497	2	vinic
xenic	14	41	1464	2	xenic
yogic	11	61	1493	2	yogic
yoni	7	75	2439	2	yoni_
yonis	8	50	2082	2	yonis
zoic	15	23	1607	2	zo_ic

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	53800	0.296	603685.8
2	DLD Change Limit	53800	80	1.406	38264.6
3	Display Results	80	80	0.016	5000.0
	(SQL Overall)	178691	80	1.718	104011.1