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

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

156 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
stove	8	52	2025	(None)
shove	11	44	2104	1	shove
stave	8	53	2499	1	stave
stoae	5	50	2426	1	stoae
stoke	9	49	2251	1	stoke
stole	5	49	2881	1	stole
stone	5	54	3118	1	stone
stope	7	47	2724	1	stope
store	5	63	3381	1	store
stover	9	41	1564	1	stover
stoves	9	38	1892	1	stoves
strove	9	50	1479	1	strove
above	10	54	1432	2	above
atone	5	65	2798	2	atone
clove	10	56	1944	2	clove
cove	9	58	3707	2	_cove
dove	8	51	3156	2	_dove
drove	9	55	1806	2	drove
glove	9	45	1629	2	glove
grove	9	52	1933	2	grove
hove	10	71	3222	2	_hove
love	7	52	3476	2	_love
move	9	66	3072	2	_move
poove	10	45	1430	2	poove
prove	10	48	2319	2	prove
rove	7	51	3698	2	_rove
salve	8	50	2213	2	salve
save	7	57	4136	2	s_ave
scone	7	46	2183	2	scone
scope	9	48	2148	2	scope
score	7	55	2674	2	score
serve	8	54	2596	2	serve
setose	6	51	1477	2	setose
shave	11	44	2589	2	shave
shive	11	44	2342	2	shive
shoe	7	59	3344	2	sho_e
shone	8	37	2598	2	shone
shore	8	54	3265	2	shore
shote	8	55	2610	2	shote
shoved	13	42	1428	2	shoved
shovel	12	46	1132	2	shovel
shover	12	45	1599	2	shover
shoves	12	49	1942	2	shoves
shrove	12	54	1223	2	shrove
sieve	8	49	1884	2	sieve
skive	12	46	1411	2	skive
slave	8	42	2403	2	slave
sloe	4	55	3495	2	slo_e
slope	7	58	2356	2	slope
sloven	9	38	963	2	sloven
smoke	11	50	1582	2	smoke
smote	7	58	2028	2	smote
snore	5	54	2495	2	snore
soave	8	42	1905	2	soave
soke	8	54	3626	2	s_oke
sole	4	60	5367	2	s_ole
solve	8	56	1894	2	solve
some	6	60	4038	2	s_ome
sone	4	66	4998	2	s_one
sore	4	70	5953	2	s_ore
spode	8	46	1770	2	spode
spoke	11	48	1866	2	spoke
spore	7	54	2859	2	spore
stade	6	48	2530	2	stade
stage	6	53	3019	2	stage
stake	9	59	2753	2	stake
stale	5	56	3710	2	stale
stane	5	59	3300	2	stane
stare	5	44	4026	2	stare
starve	9	46	1374	2	starve
state	5	62	3733	2	state
staved	10	39	1805	2	staved
staves	9	45	2519	2	staves
steeve	9	37	1090	2	steeve
stele	5	50	2684	2	stele
stere	5	53	2854	2	stere
stile	5	49	3157	2	stile
stime	7	65	2180	2	stime
stipe	7	65	2337	2	stipe
stiver	9	39	1573	2	stiver
stoa	4	54	2591	2	sto_a
stoai	5	54	1787	2	stoai
stoas	5	51	2602	2	stoas
stoat	5	71	3595	2	stoat
stob	6	67	2461	2	sto_b
stobs	7	57	1823	2	stobs
stock	11	44	1756	2	stock
stodge	8	36	904	2	stodge
stogey	10	58	1154	2	stogey
stogie	7	3	1132	2	stogie
stogy	9	54	1408	2	stogy
stoic	7	3	1725	2	stoic
stoked	11	47	1829	2	stoked
stoker	10	44	1762	2	stoker
stokes	10	48	2179	2	stokes
stoled	7	45	2159	2	stoled
stolen	6	43	1506	2	stolen
stoles	6	39	2767	2	stoles
stoma	7	59	1827	2	stoma
stomp	9	56	1666	2	stomp
stoned	7	59	2314	2	stoned
stoner	6	58	2320	2	stoner
stones	6	51	3003	2	stones
stoney	9	62	1735	2	stoney
stony	8	58	1864	2	stony
stood	6	55	1771	2	stood
stooge	7	38	1166	2	stooge
stook	9	52	1821	2	stook
stool	5	56	1989	2	stool
stoop	7	58	2154	2	stoop
stop	6	65	3203	2	sto_p
stoped	9	47	2101	2	stoped
stoper	8	43	2010	2	stoper
stopes	8	45	2589	2	stopes
stops	7	48	2728	2	stops
stopt	7	65	2835	2	stopt
stored	7	55	2421	2	stored
storer	6	47	2167	2	storer
stores	6	55	3366	2	stores
storey	9	52	1761	2	storey
stork	9	68	1969	2	stork
storm	7	65	2040	2	storm
story	8	67	2303	2	story
stoss	5	43	1634	2	stoss
stot	4	63	4733	2	sto_t
stots	5	48	2855	2	stots
stott	5	69	2979	2	stott
stoup	7	55	1707	2	stoup
stour	5	49	1674	2	stour
stoure	6	48	1494	2	stoure
stout	5	74	3405	2	stout
stovers	10	37	1373	2	stovers
stow	7	73	2574	2	sto_w
stowed	10	58	1720	2	stowed
stowp	10	56	1423	2	stowp
stows	8	66	2270	2	stows
strive	9	50	2096	2	strive
strobe	8	45	1381	2	strobe
strode	7	52	1597	2	strode
stroke	10	51	1617	2	stroke
stupe	7	52	1775	2	stupe
stye	7	62	1897	2	st_ye
style	8	55	1936	2	style
suave	8	35	1987	2	suave
swive	11	53	1619	2	swive
swore	8	49	2082	2	swore
toe	3	101	6685	2	_to_e
toke	8	67	3849	2	_toke
tole	4	60	5290	2	_tole
tome	6	75	4319	2	_tome
tone	4	69	5374	2	_tone
tope	6	59	4638	2	_tope
tore	4	73	5932	2	_tore
tote	4	66	4367	2	_tote
trove	8	52	2192	2	trove
wove	10	56	2431	2	_wove

Search took 7 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	1.093	163486.7
2	DLD Change Limit	53800	156	4.343	12387.8
3	Display Results	156	156	0.046	3391.3
	(SQL Overall)	178691	156	5.482	32596.0