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

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

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

110 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
solve	8	56	1894	(None)
salve	8	50	2213	1	salve
soave	8	42	1905	1	soave
sole	4	60	5367	1	sol_e
solved	10	53	1293	1	solved
solver	9	40	1670	1	solver
solves	9	50	1822	1	solves
absolve	12	4	451	2	absolve
bole	6	64	4869	2	bol_e
calve	10	59	1992	2	calve
clove	10	56	1944	2	clove
cole	6	69	5611	2	col_e
cove	9	58	3707	2	co_ve
delve	9	60	1826	2	delve
dolce	8	58	1668	2	dolce
dole	5	65	5000	2	dol_e
dove	8	51	3156	2	do_ve
evolve	12	30	650	2	evolve
glove	9	45	1629	2	glove
halve	11	48	1892	2	halve
helve	11	50	1809	2	helve
hole	7	75	5339	2	hol_e
hove	10	71	3222	2	ho_ve
jole	11	72	3382	2	jol_e
love	7	52	3476	2	lo_ve
mole	6	62	5183	2	mol_e
move	9	66	3072	2	mo_ve
ole	3	71	5521	2	_ol_e
olive	8	48	1715	2	_olive
pole	6	59	5130	2	pol_e
poove	10	45	1430	2	poove
resolve	10	39	1098	2	resolve
role	4	58	5182	2	rol_e
rove	7	51	3698	2	ro_ve
sale	4	49	5970	2	sal_e
salved	10	39	1642	2	salved
salver	9	46	1775	2	salver
salves	9	42	2176	2	salves
salvo	8	44	1564	2	salvo
save	7	57	4136	2	s_ave
selle	5	44	2831	2	selle
selva	8	30	1427	2	selva
selves	9	41	1961	2	selves
serve	8	54	2596	2	serve
shave	11	44	2589	2	shave
shelve	12	40	1276	2	shelve
shive	11	44	2342	2	shive
shove	11	44	2104	2	shove
sieve	8	49	1884	2	sieve
silva	8	27	1402	2	silva
silvae	9	28	1109	2	silvae
silver	9	38	1581	2	silver
silvex	16	33	672	2	silvex
skive	12	46	1411	2	skive
slave	8	42	2403	2	slave
sloe	4	55	3495	2	s_loe
slope	7	58	2356	2	slope
sloven	9	38	963	2	sloven
slue	4	53	3219	2	s_lue
soaves	9	42	1867	2	soaves
socle	7	4	1957	2	socle
soever	9	44	1209	2	soever
soke	8	54	3626	2	so_ke
sol	3	72	5662	2	sol__
sola	4	55	4186	2	sol_a
solace	8	34	1582	2	solace
solan	5	53	2815	2	solan
solar	5	59	2734	2	solar
solate	6	45	2607	2	solate
sold	5	48	3741	2	sol_d
solder	7	39	2134	2	solder
soldi	6	57	1720	2	soldi
soldo	6	71	1656	2	soldo
soled	6	58	3517	2	soled
solei	5	56	2434	2	solei
soles	5	55	4792	2	soles
solgel	7	3	796	2	solgel
soli	4	66	3701	2	sol_i
solid	6	50	2508	2	solid
solo	4	55	3894	2	sol_o
soloed	7	45	1574	2	soloed
solon	5	50	2613	2	solon
solos	5	48	3079	2	solos
sols	4	54	4816	2	sol_s
solum	7	47	1761	2	solum
solus	5	47	2698	2	solus
solute	6	40	1666	2	solute
solvate	10	27	1021	2	solvate
solvent	10	3	1083	2	solvent
solvers	10	44	1425	2	solvers
some	6	60	4038	2	so_me
sonde	6	46	2283	2	sonde
sone	4	66	4998	2	so_ne
sore	4	70	5953	2	so_re
souse	5	65	3077	2	souse
stave	8	53	2499	2	stave
stole	5	49	2881	2	stol_e
stove	8	52	2025	2	stove
suave	8	35	1987	2	suave
swive	11	53	1619	2	swive
sylva	11	26	844	2	sylva
sylvae	12	23	686	2	sylvae
tole	4	60	5290	2	tol_e
valve	11	45	1593	2	valve
vole	7	52	3698	2	vol_e
volte	8	53	2130	2	volte
volva	11	39	900	2	volva
wolver	12	41	971	2	wolver
wolves	12	45	1085	2	wolves
wove	10	56	2431	2	wo_ve

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.330	541487.9
2	DLD Change Limit	53800	110	1.640	32804.9
3	Display Results	110	110	0.030	3666.7
	(SQL Overall)	178691	110	2.000	89345.5