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

Here are the results of your fuzzy-string dictionary search for “scion” 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.

47 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
scion	7	22	1499	(None)
cion	6	133	3091	1	_cion
scions	8	26	1224	1	scions
action	8	47	1968	2	action
anion	5	50	2881	2	anion
avion	8	42	1834	2	avion
axion	12	113	1691	2	axion
chon	9	66	2779	2	_chon
cions	7	52	2285	2	_cions
clon	6	62	3248	2	_clon
coin	6	66	4535	2	_coin
con	5	102	6802	2	_c_on
coon	6	72	4894	2	_coon
icon	6	69	2204	2	ic_on
inion	5	46	2018	2	inion
ion	3	60	5102	2	__ion
lion	4	63	3444	2	_lion
onion	5	43	2097	2	onion
pion	6	72	3529	2	_pion
prion	7	51	1999	2	prion
sain	4	55	5129	2	sai_n
salon	5	52	2855	2	salon
scan	6	55	3045	2	sc_an
scone	7	46	2183	2	sc_one
scoop	9	56	1716	2	scoop
scoot	7	57	2915	2	scoot
scop	8	59	2552	2	sc_op
scorn	7	58	1745	2	scorn
scot	6	62	4261	2	sc_ot
scow	9	60	2142	2	sc_ow
scrod	8	51	1507	2	scrod
section	9	25	1566	2	section
seton	5	52	2354	2	seton
shin	7	56	3431	2	shi_n
shoon	8	40	2201	2	shoon
sign	5	55	2305	2	s_ign
sin	3	62	6589	2	s_i_n
skin	8	59	2753	2	ski_n
solion	6	6	1638	2	solion
solon	5	50	2613	2	solon
son	3	77	6195	2	s__on
soon	4	62	4050	2	s_oon
spin	6	62	3130	2	spi_n
spoon	7	47	1944	2	spoon
suction	9	37	1304	2	suction
swoon	8	50	1478	2	swoon
union	5	45	1979	2	union

Search took 3 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.313	570897.8
2	DLD Change Limit	53800	47	1.716	31352.0
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	2.045	87379.5