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

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

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.

60 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
stockpiling	20	5	156	(None)
stickling	16	4	700	3	stick__ling
stockading	18	4	302	3	stock_ading
stocking	15	29	1250	3	stock___ing
stockpile	17	4	303	3	stockpil__e
stockpiled	19	5	203	3	stockpil_ed
stockpiler	18	4	233	3	stockpil_er
stockpilers	19	6	191	3	stockpilers
stockpiles	18	4	299	3	stockpil_es
stocktaking	17	8	209	3	stocktaking
stoppling	14	7	496	3	sto__ppling
cockbilling	22	5	249	4	_cockbilling
cockling	17	23	1039	4	_cock__ling
cocktailing	20	5	278	4	_cocktailing
compiling	16	3	776	4	_co_mpiling
recompiling	18	4	399	4	recompiling
rockling	15	25	938	4	_rock__ling
shackling	19	28	617	4	shack__ling
shocking	18	43	1154	4	shock___ing
sickling	15	29	1033	4	s_ick__ling
smocking	17	34	910	4	smock___ing
snorkeling	15	4	297	4	snork_eling
socketing	16	6	638	4	s_ock_eting
socking	14	35	1860	4	s_ock___ing
soiling	8	34	2232	4	s_o___iling
sopiting	11	3	1076	4	s_o__piting
spackling	18	26	650	4	spack__ling
speckling	18	23	558	4	speck__ling
spiling	10	29	1970	4	s____piling
spoiling	11	29	1155	4	spo___iling
stacking	15	42	1508	4	stack___ing
stapling	11	28	1315	4	st__ap_ling
stenciling	13	4	417	4	st_enciling
sticking	15	35	1346	4	stick___ing
stickpin	16	4	376	4	stickp__in_
stickpins	17	4	409	4	stickp__ins
stippling	14	7	517	4	st__ippling
stockbroking	20	6	143	4	stockbroking
stockily	17	3	544	4	stock_il__y
stockings	16	29	609	4	stock___ings
stockjobbing	30	13	90	4	stockjobbing
stocktakings	18	10	151	4	stocktakings
stoking	12	36	1559	4	sto_k___ing
stomping	13	30	976	4	sto_mp__ing
stooking	13	27	1114	4	stook___ing
stooling	9	31	1313	4	sto___oling
stooping	11	30	1236	4	sto_op__ing
stoping	10	37	1662	4	sto__p__ing
stoppering	15	4	461	4	sto_ppering
stopping	13	36	1141	4	sto__p_ping
strickling	17	4	495	4	strick__ling
stripling	12	5	778	4	st_rip_ling
subceiling	15	4	519	4	subc_eiling
suckling	15	24	1002	4	s_uck__ling
tackling	15	32	1112	4	_tack__ling
tickling	15	30	943	4	_tick__ling
toenailing	11	4	357	4	_toenailing
toiling	8	32	1902	4	_to___iling
toppling	13	19	735	4	_to__ppling
topsoiling	13	4	322	4	_topsoiling

Search took 10 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	148819	0.453	394461.4
2	DLD Change Limit	148819	60	9.233	16118.2
3	Display Results	60	60	0.033	1818.2
	(SQL Overall)	178691	60	9.719	18385.7