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

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

87 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
spinner	9	39	1226	(None)
pinner	8	45	2150	1	_pinner
sinner	6	43	2060	1	s_inner
skinner	11	34	809	1	skinner
spanner	9	43	1256	1	spanner
spinier	9	37	1516	1	spinier
spinners	10	38	1086	1	spinners
spinnery	13	41	659	1	spinnery
spinney	12	43	892	1	spinney
aginner	8	4	466	2	aginner
dinner	7	42	1716	2	_dinner
ginner	7	39	1582	2	_ginner
grinner	8	32	923	2	grinner
inner	5	49	2063	2	__inner
panner	8	42	2476	2	_panner
penner	8	46	1666	2	_penner
pincer	10	40	1917	2	_pincer
pinder	9	45	2345	2	_pinder
pinger	9	43	2409	2	_pinger
pinier	8	40	2469	2	_pinier
pinker	12	53	2244	2	_pinker
pinned	9	48	1838	2	_pinned
pinners	9	35	1860	2	_pinners
punner	8	49	1815	2	_punner
scanner	9	44	1181	2	scanner
scunner	9	35	824	2	scunner
seiner	6	46	2248	2	sei_ner
shiner	9	38	2087	2	shi_ner
shinier	10	41	1314	2	shinier
shinned	11	43	1091	2	shinned
shinnery	14	30	567	2	shinnery
shinney	13	36	829	2	shinney
shunner	10	35	864	2	shunner
signer	7	40	1563	2	s_igner
singer	7	42	2731	2	s_inger
sinker	10	36	2090	2	s_inker
sinned	7	38	1841	2	s_inned
sinners	7	40	1902	2	s_inners
sinter	6	36	2592	2	s_inter
skinker	10	31	944	2	skinker
skinned	12	38	729	2	skinned
skinners	12	34	729	2	skinners
skinnier	12	6	489	2	skinnier
slinger	8	34	1383	2	slinger
spanker	13	36	1235	2	spanker
spanned	10	41	1122	2	spanned
spanners	10	37	1077	2	spanners
spawner	12	34	736	2	spawner
spencer	11	36	1097	2	spencer
spender	10	37	1369	2	spender
spicer	10	47	1931	2	spi_cer
spicier	11	51	1246	2	spicier
spider	9	45	1680	2	spi_der
spieler	9	31	1123	2	spieler
spier	7	57	2803	2	spi__er
spiker	12	43	1566	2	spi_ker
spikier	13	36	998	2	spikier
spiller	9	29	1433	2	spiller
spindler	11	29	798	2	spindler
spine	7	65	3442	2	spi_ne_
spined	9	54	2394	2	spi_ned
spinel	8	53	1733	2	spi_nel
spines	8	51	3203	2	spi_nes
spinet	8	56	2975	2	spi_net
spinnaker	15	4	231	2	spinnaker
spinneret	11	4	619	2	spinneret
spinneys	13	33	555	2	spinneys
spinnies	10	32	1054	2	spinnies
spinny	11	45	1018	2	spinn_y
spinor	8	3	994	2	spi_nor
spinster	10	3	668	2	spinster
spirier	9	32	1407	2	spirier
spitter	9	40	1518	2	spitter
splinter	10	32	970	2	splinter
sponger	10	3	852	2	sponger
springer	11	33	1175	2	springer
sprinter	10	38	1081	2	sprinter
spurner	9	26	965	2	spurner
stinger	8	43	1468	2	stinger
stinker	11	33	1331	2	stinker
stinter	7	36	1451	2	stinter
stunner	7	34	919	2	stunner
swinger	11	38	1256	2	swinger
swinney	13	36	597	2	swinney
thinner	10	35	897	2	thinner
tinner	6	41	1996	2	_tinner
winner	9	42	1993	2	_winner

Search took 4 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	107671	0.360	496363.9
2	DLD Change Limit	107671	87	3.140	34290.1
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	3.530	50620.7