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

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

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.

55 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
spinoffs	16	4	277	(None)
spinoff	15	4	493	1	spinoff_
spiffs	14	32	847	2	spi__ffs
spinors	9	3	942	2	spino_rs
spinous	9	3	1044	2	spino_us
spinouts	10	3	602	2	spinouts
boiloffs	16	4	198	3	boiloffs
dieoffs	14	4	303	3	_dieoffs
payoffs	18	4	324	3	_payoffs
pickoffs	22	4	237	3	_pickoffs
pilaffs	15	36	515	3	_pilaffs
pinoles	9	34	1870	3	_pinoles
pinones	9	47	1707	3	_pinones
pinons	8	60	1994	3	_pino_ns
pinots	8	59	2027	3	_pino_ts
putoffs	15	4	333	3	_putoffs
ripoffs	15	4	338	3	_ripoffs
runoffs	13	4	301	3	_runoffs
scoffs	14	34	750	3	s__coffs
selloffs	14	4	363	3	selloffs
sendoffs	15	4	349	3	sendoffs
setoffs	13	3	413	3	s_etoffs
showoffs	20	4	245	3	showoffs
shroffs	16	3	436	3	s_hroffs
shutoffs	17	5	207	3	shutoffs
skiffs	16	32	701	3	ski__ffs
sniffs	12	37	884	3	s__niffs
snuffs	12	35	853	3	s__nuffs
spiff	13	36	1640	3	spi__ff_
spiffy	17	32	622	3	spi__ffy
spigots	10	3	779	3	spigo_ts
spinages	11	28	929	3	spinages
spinals	9	39	1186	3	spin_als
spindles	11	27	1035	3	spindles
spinels	9	45	1244	3	spin_els
spines	8	51	3203	3	spin__es
spinets	9	47	1481	3	spin_ets
spinifex	20	4	205	3	spinifex
spinless	10	23	870	3	spinless
spinners	10	38	1086	3	spinners
spinneys	13	33	555	3	spinneys
spinnies	10	32	1054	3	spinnies
spinor	8	3	994	3	spino__r
spinose	9	3	794	3	spino_se
spinout	9	3	1158	3	spino_ut
spins	7	53	2798	3	spin___s
spintos	9	3	913	3	spin_tos
spinules	10	24	933	3	spinules
spliffs	15	3	356	3	sp_liffs
spoofs	11	40	1181	3	sp__oofs
standoffs	16	4	267	3	standoffs
stiffs	12	38	996	3	sti__ffs
stopoffs	16	6	299	3	stopoffs
tipoffs	15	4	303	3	_tipoffs
turnoffs	14	4	283	3	turnoffs

Search took 8 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	146162	0.420	425454.8
2	DLD Change Limit	146162	55	7.503	19480.5
3	Display Results	55	55	0.013	4230.8
	(SQL Overall)	178691	55	7.936	22516.5