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

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

65 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
sprinklers	16	4	297	(None)
sprinkler	15	4	357	1	sprinkler_
sprinkles	15	3	492	1	sprinkle_s
prinkers	14	30	1038	2	_prink_ers
shrinkers	16	20	538	2	shrink_ers
spindlers	12	28	645	2	sp_indlers
springers	12	30	998	2	sprin_gers
springlets	13	4	402	2	springlets
sprinkle	14	3	489	2	sprinkle__
sprinkled	16	3	371	2	sprinkle_d
sprinklered	18	5	126	2	sprinklered
sprinters	11	32	936	2	sprin_ters
besprinkles	19	5	110	3	besprinkle_s
crinkles	14	26	916	3	_crinkle_s
drinkers	13	27	782	3	_drink_ers
pinkers	13	41	1860	3	_p_ink_ers
plinkers	14	30	939	3	_plink_ers
prickers	16	37	1067	3	_prick_ers
prickles	16	25	1109	3	_prickle_s
prinker	13	34	1274	3	_prink_er_
printers	10	32	1490	3	_prin_ters
printless	11	3	751	3	_printless
scribblers	16	18	310	3	scribblers
shinglers	13	24	644	3	s_hinglers
shriekers	16	22	442	3	shriek_ers
shrinker	15	23	636	3	shrink_er_
sinkers	11	36	1854	3	s__ink_ers
skinkers	11	29	818	3	s_kink_ers
spankers	14	36	986	3	sp_ank_ers
sparklers	15	31	564	3	sp_arklers
sphincters	17	4	207	3	sphincters
spielers	10	31	965	3	sp_i_elers
spikers	13	53	1199	3	sp_i_k_ers
spillers	10	33	1170	3	sp_i_llers
spindler	11	29	798	3	sp_indler_
spindles	11	27	1035	3	sp_indle_s
spineless	11	3	613	3	sp_ineless
spinless	10	23	870	3	sp_in_less
spinners	10	38	1086	3	sp_in_ners
spinsters	11	3	661	3	sp_insters
spinules	10	24	933	3	sp_inule_s
splinters	11	27	792	3	splin_ters
spoilers	10	23	863	3	spoi__lers
sprawlers	14	3	389	3	spr_awlers
spriggers	13	32	549	3	spri_ggers
springer	11	33	1175	3	sprin_ger_
springes	11	40	1403	3	sprin_ge_s
springier	12	3	602	3	springier_
springlet	12	5	752	3	springle_t
sprinklering	19	5	108	3	sprinklering
sprinkling	17	4	382	3	sprinkling
sprinklings	18	4	185	3	sprinklings
sprinter	10	38	1081	3	sprin_ter_
spritzers	20	4	390	3	spri_tzers
sticklers	15	22	739	3	s_ticklers
stinkers	12	31	1113	3	s_tink_ers
stranglers	11	39	682	3	stranglers
strickles	15	6	781	3	strickle_s
strikers	12	36	1129	3	stri_k_ers
stringers	10	42	1064	3	strin_gers
stringless	11	4	535	3	stringless
swindlers	13	30	603	3	s_windlers
tinklers	12	29	818	3	__tinklers
twinklers	16	3	306	3	_twinklers
wrinkles	15	29	669	3	_wrinkle_s

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	140603	0.156	1145455.1
2	DLD Change Limit	140603	65	6.516	21578.1
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	6.688	26718.2