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

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

77 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
spinners	10	38	1086	(None)
pinners	9	35	1859	1	_pinners
sinners	7	40	1901	1	s_inners
skinners	12	34	728	1	skinners
spanners	10	37	1077	1	spanners
spinner	9	39	1226	1	spinner_
spinnery	13	41	658	1	spinnery
spinneys	13	33	555	1	spinneys
aginners	9	5	462	2	aginners
dinners	8	39	1543	2	_dinners
ginners	8	43	1421	2	_ginners
grinners	9	28	804	2	grinners
inners	6	39	1934	2	__inners
panners	9	36	2127	2	_panners
penners	9	34	1418	2	_penners
pincers	11	39	1650	2	_pincers
pinders	10	37	2047	2	_pinders
pingers	10	40	2073	2	_pingers
pinkers	13	41	1860	2	_pinkers
pinner	8	45	2149	2	_pinner_
punners	9	41	1423	2	_punners
scanners	10	37	970	2	scanners
scunners	10	35	730	2	scunners
seiners	7	42	1927	2	sei_ners
shiners	10	40	1594	2	shi_ners
shinnery	14	30	566	2	shinnery
shinneys	14	27	509	2	shinneys
shunners	11	31	774	2	shunners
signers	8	47	1442	2	s_igners
singers	8	38	2469	2	s_ingers
sinkers	11	36	1854	2	s_inkers
sinner	6	43	2059	2	s_inner_
sinters	7	40	2407	2	s_inters
skinkers	11	29	817	2	skinkers
skinner	11	34	809	2	skinner_
slingers	9	37	1267	2	slingers
spankers	14	36	986	2	spankers
spanner	9	43	1256	2	spanner_
spawners	13	39	649	2	spawners
spencers	12	26	919	2	spencers
spenders	11	32	1174	2	spenders
spicers	11	38	1555	2	spi_cers
spiders	10	39	1441	2	spi_ders
spielers	10	31	964	2	spielers
spiers	8	44	2174	2	spi__ers
spikers	13	53	1199	2	spi_kers
spillers	10	33	1169	2	spillers
spindlers	12	28	645	2	spindlers
spinels	9	45	1244	2	spi_nels
spines	8	51	3203	2	spi_ne_s
spinets	9	47	1481	2	spi_nets
spinier	9	37	1516	2	spinier_
spininess	11	3	796	2	spininess
spinless	10	23	870	2	spinless
spinnakers	16	4	191	2	spinnakers
spinneret	11	4	619	2	spinneret
spinnerets	12	4	254	2	spinnerets
spinneries	12	4	573	2	spinneries
spinney	12	43	892	2	spinne_y
spinnies	10	32	1054	2	spinnies
spinors	9	3	941	2	spi_nors
spinsters	11	3	660	2	spinsters
spitters	10	41	1338	2	spitters
splinters	11	27	792	2	splinters
spongers	11	3	760	2	spongers
springers	12	30	998	2	springers
sprinters	11	32	936	2	sprinters
spurners	10	28	849	2	spurners
stingers	9	40	1273	2	stingers
stinkers	12	31	1112	2	stinkers
stinters	8	33	1274	2	stinters
stunners	8	27	792	2	stunners
swingers	12	37	1042	2	swingers
swinneys	14	26	420	2	swinneys
thinners	11	32	774	2	thinners
tinners	7	37	1730	2	_tinners
winners	10	43	1690	2	_winners

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	121059	0.143	1249587.4
2	DLD Change Limit	121059	77	6.466	18722.4
3	Display Results	77	77	0.063	1222.2
	(SQL Overall)	178691	77	6.672	26782.2