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

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

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
spinelles	11	4	608	(None)
spinelle	10	4	622	1	spinelle_
spindles	11	27	1035	2	spin_dles
spineless	11	3	613	2	spineless
spinels	9	45	1244	2	spine_l_s
spinules	10	24	933	2	spin_ules
cineoles	10	10	940	3	_cineoles
crenelles	11	4	673	3	crenelles
micelles	12	8	883	3	_micelles
panelled	11	3	896	3	_panelled
pineals	9	32	1284	3	_pineal_s
pinenes	9	34	1667	3	_pine_nes
pineries	10	24	1908	3	_pineries
pinholes	13	18	1066	3	_pinholes
pinnules	10	3	646	3	_pinnules
pinocles	12	4	869	3	_pinocles
pinoles	9	34	1870	3	_pin_oles
pintles	9	41	1872	3	_pin_tles
pinwales	13	6	796	3	_pinwales
pizzelles	19	4	294	3	_pizzelles
pointelles	12	4	501	3	pointelles
prunelles	11	4	506	3	prunelles
quenelles	18	4	398	3	quenelles
quinellas	18	4	379	3	quinellas
selles	6	44	2698	3	s___elles
shigellas	13	4	314	3	shigellas
shingles	12	31	1111	3	shin_gles
sinewless	12	4	436	3	s_inewless
singles	8	35	2043	3	s_in_gles
snelled	8	33	1304	3	s__nelled
sneller	7	35	1284	3	s__neller
snellest	8	3	949	3	s__nellest
snells	6	46	1420	3	s__nell_s
snivelled	13	5	399	3	snivelled
sniveller	12	5	370	3	sniveller
snivellers	13	5	287	3	snivellers
spadilles	12	4	499	3	spadilles
spancelled	15	4	300	3	spancelled
spangles	11	3	889	3	span_gles
spansules	11	4	361	3	spansules
spelled	10	37	1473	3	sp__elled
speller	9	54	1514	3	sp__eller
spellers	10	28	1275	3	sp__ellers
spells	8	46	1768	3	sp__ell_s
spiceless	13	3	592	3	spiceless
spiceries	13	4	931	3	spiceries
spicules	12	21	980	3	spi_cules
spiegels	11	3	387	3	spi_egels
spieled	10	48	1188	3	spi_e_led
spieler	9	31	1123	3	spi_e_ler
spielers	10	31	965	3	spi_elers
spiels	8	53	1795	3	spi_e_l_s
spikelet	14	4	653	3	spike_let
spikelets	15	5	339	3	spikelets
spiles	8	42	2791	3	spi___les
spilled	10	36	1362	3	spi__lled
spiller	9	29	1433	3	spi__ller
spillers	10	33	1170	3	spi__llers
spills	8	47	1746	3	spi__ll_s
spinaches	16	4	527	3	spinaches
spinages	11	28	929	3	spin_ages
spinally	13	3	802	3	spinall_y
spinals	9	39	1186	3	spin_al_s
spindle	10	32	1009	3	spin_dle_
spindled	12	28	764	3	spin_dled
spindler	11	29	798	3	spin_dler
spindlers	12	28	645	3	spindlers
spindlier	12	5	387	3	spindlier
spindliest	13	4	448	3	spindliest
spinel	8	53	1733	3	spine_l__
spinelike	15	8	535	3	spinelike
spines	8	51	3203	3	spin___es
spinets	9	47	1481	3	spine__ts
spinless	10	23	870	3	spin_less
spinneries	12	4	573	3	spinneries
spinnies	10	32	1054	3	spin_nies
spinulae	10	27	696	3	spinulae_
spinule	9	29	999	3	spin_ule_
spinulose	11	4	291	3	spinulose
spiracles	13	4	566	3	spiracles
spiralled	12	4	440	3	spiralled
spiremes	12	39	762	3	spire_mes
spittles	10	3	833	3	spi_ttles
sprinkles	15	3	492	3	sprin_kles
swindles	12	31	950	3	swin_dles
swingles	12	31	954	3	swin_gles
swivelled	16	6	296	3	swivelled

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	148641	0.436	409841.7
2	DLD Change Limit	148641	87	6.766	21968.8
3	Display Results	87	87	0.033	2636.4
	(SQL Overall)	178691	87	7.235	24698.1