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

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

74 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
spinning	11	33	1081	(None)
pinning	10	34	1785	1	_pinning
shinning	12	32	1102	1	shinning
sinning	8	39	1844	1	s_inning
skinning	13	32	789	1	skinning
spanning	11	33	1108	1	spanning
spinnings	12	29	485	1	spinnings
binning	10	36	1545	2	_binning
chinning	14	32	965	2	chinning
dinning	9	34	1655	2	_dinning
finning	11	36	1511	2	_finning
ginning	9	33	1398	2	_ginning
grinning	10	3	786	2	grinning
inning	7	36	1763	2	__inning
opining	10	3	1174	2	opi_ning
panning	10	40	1939	2	_panning
penning	10	36	1649	2	_penning
pinging	11	34	1955	2	_pinging
pining	9	37	2653	2	_pi_ning
pinking	14	39	1894	2	_pinking
punning	10	34	1499	2	_punning
repinning	12	25	897	2	repinning
rinning	8	32	1674	2	_rinning
saining	8	36	2139	2	sai_ning
sainting	9	32	1573	2	sainting
scanning	11	33	1077	2	scanning
seining	8	40	2077	2	sei_ning
shining	11	38	1652	2	shi_ning
shinnying	16	19	372	2	shinnying
shunning	12	36	784	2	shunning
signing	9	27	1396	2	s_igning
singing	9	32	2142	2	s_inging
sinking	12	33	2054	2	s_inking
skinking	12	29	977	2	skinking
slinging	10	33	1286	2	slinging
slinking	13	34	1298	2	slinking
spanking	15	39	1197	2	spanking
spawning	14	29	691	2	spawning
speaning	11	35	1224	2	speaning
spending	12	27	1243	2	spending
spicing	12	39	1453	2	spi_cing
spieling	11	32	1252	2	spieling
spiering	11	27	1335	2	spiering
spiffing	17	23	708	2	spiffing
spiking	14	43	1288	2	spi_king
spiling	10	29	1970	2	spi_ling
spilling	11	31	1394	2	spilling
spindling	13	13	627	2	spindling
spinnies	10	32	1054	2	spinnies
spiring	10	39	1818	2	spi_ring
spirting	11	29	1363	2	spirting
spiting	10	39	1762	2	spi_ting
spitting	11	30	1232	2	spitting
splining	11	3	1077	2	splining
splinting	12	3	819	2	splinting
sponging	12	3	882	2	sponging
spooning	11	28	1144	2	spooning
springing	13	3	874	2	springing
sprinting	12	3	1003	2	sprinting
spunking	15	25	806	2	spunking
spurning	11	25	866	2	spurning
stinging	10	32	1345	2	stinging
stinking	13	31	1354	2	stinking
stinting	9	34	1574	2	stinting
stunning	9	29	846	2	stunning
sunning	8	37	1567	2	s_unning
swanning	12	33	881	2	swanning
swinging	13	34	1111	2	swinging
swinking	16	34	1032	2	swinking
thinning	12	31	909	2	thinning
tinning	8	31	1728	2	_tinning
twinning	12	36	704	2	twinning
unpinning	12	4	562	2	unpinning
winning	11	35	1655	2	_winning

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	74	3.716	32577.8
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	4.139	43172.5