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

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

72 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
spinoff	15	4	493	(None)
spinoffs	16	4	277	1	spinoffs
spiff	13	36	1640	2	spi__ff
spinor	8	3	994	2	spino_r
spinors	9	3	942	2	spinors
spinose	9	3	794	2	spinose
spinous	9	3	1044	2	spinous
spinout	9	3	1158	2	spinout
boiloff	15	4	378	3	boiloff
dieoff	13	3	550	3	_dieoff
payoff	17	3	602	3	_payoff
pickoff	21	4	369	3	_pickoff
pilaff	14	39	1036	3	_pilaff
pinole	8	32	1878	3	_pinole
pinon	7	60	2453	3	_pino_n
pinons	8	60	1994	3	_pinons
pinot	7	87	3729	3	_pino_t
pinots	8	59	2027	3	_pinots
putoff	14	3	642	3	_putoff
ripoff	14	3	643	3	_ripoff
runoff	12	3	541	3	_runoff
scoff	13	44	1334	3	s__coff
selloff	13	4	592	3	selloff
sendoff	14	4	623	3	sendoff
setoff	12	3	891	3	s_etoff
showoff	19	4	389	3	showoff
shroff	15	3	850	3	s_hroff
shutoff	16	9	320	3	shutoff
skiff	15	36	1281	3	ski__ff
sniff	11	39	1586	3	s__niff
snuff	11	35	1404	3	s__nuff
spiffs	14	32	847	3	spi_ffs
spiffy	17	32	622	3	spi_ffy
spigot	9	3	1260	3	spigo_t
spigots	10	3	779	3	spigots
spin	6	62	3130	3	spin___
spinach	14	3	540	3	spinach
spinage	10	28	965	3	spinage
spinal	8	49	1531	3	spin_al
spinals	9	39	1186	3	spinals
spinate	9	31	1481	3	spinate
spindle	10	32	1009	3	spindle
spindly	13	25	738	3	spindly
spine	7	65	3442	3	spin__e
spined	9	54	2394	3	spin_ed
spinel	8	53	1733	3	spin_el
spinels	9	45	1244	3	spinels
spines	8	51	3203	3	spin_es
spinet	8	56	2975	3	spin_et
spinets	9	47	1481	3	spinets
spinier	9	37	1516	3	spinier
spinifex	20	4	205	3	spinifex
spinner	9	39	1226	3	spinner
spinney	12	43	892	3	spinney
spinny	11	45	1018	3	spin_ny
spinouts	10	3	602	3	spinouts
spins	7	53	2798	3	spin__s
spinto	8	4	1066	3	spin_to
spintos	9	3	913	3	spintos
spinula	9	25	790	3	spinula
spinule	9	29	999	3	spinule
spiny	10	49	2130	3	spin__y
spiroid	10	21	982	3	spiroid
spliff	14	3	860	3	sp_liff
spoof	10	50	1901	3	sp__oof
spoofs	11	40	1181	3	sp_oofs
spoofy	14	49	855	3	sp_oofy
standoff	15	4	399	3	standoff
stiff	11	42	1924	3	sti__ff
stopoff	15	6	502	3	stopoff
tipoff	14	3	638	3	_tipoff
turnoff	13	4	401	3	turnoff

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	134027	0.470	380193.6
2	DLD Change Limit	134027	72	7.250	18486.5
3	Display Results	72	72	0.013	5538.5
	(SQL Overall)	178691	72	7.733	23107.6