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

Here are the results of your fuzzy-string dictionary search for “reknitting” 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
reknitting	15	8	499	(None)
reknotting	15	6	423	1	reknotting
beknotting	17	8	281	2	beknotting
knitting	13	25	702	2	__knitting
reemitting	13	4	663	2	reemitting
refitting	13	28	1112	2	re_fitting
remitting	12	24	1262	2	re_mitting
resitting	10	34	1487	2	re_sitting
reuniting	10	3	1069	2	reuni_ting
unknitting	15	4	287	2	unknitting
befitting	15	23	662	3	be_fitting
beknighting	22	5	188	3	beknighting
demitting	13	23	907	3	de_mitting
emitting	11	24	1035	3	_e_mitting
herniating	14	4	598	3	herniating
kitting	12	32	1444	3	__k_itting
knittings	14	27	345	3	__knittings
knotting	13	23	657	3	__knotting
leniting	9	3	1235	3	le_ni_ting
permitting	15	4	630	3	permitting
preuniting	13	4	730	3	preuni_ting
readmitting	15	4	405	3	readmitting
reanimating	14	4	723	3	reanimating
reanointing	12	4	499	3	reanointing
rebaiting	12	3	1164	3	rebai_ting
rebutting	12	3	752	3	re_butting
receipting	15	4	675	3	receipting
reciting	11	31	1807	3	re_ci_ting
recutting	12	3	948	3	re_cutting
reediting	11	3	1095	3	reedi_ting
reenacting	13	5	735	3	reenacting
reenlisting	12	4	467	3	reenlisting
regretting	12	3	778	3	regretting
reigniting	12	4	637	3	reigni_ting
reinciting	13	4	710	3	reinciting
reindicting	15	4	507	3	reindicting
reinitiating	13	4	576	3	reinitiating
reinstating	12	4	811	3	reinstating
reinviting	14	4	621	3	reinviting
rekindling	16	4	352	3	rekindling
reknitted	14	4	402	3	reknitt_ed
reletting	10	27	1394	3	re_letting
relisting	10	24	1435	3	re_listing
reminting	12	23	1510	3	re_minting
renesting	10	25	1470	3	re_nesting
renigging	12	3	557	3	re_nigging
renting	8	40	2685	3	re_n__ting
repainting	13	12	897	3	repainting
replotting	13	5	704	3	replotting
repotting	12	5	1112	3	re_potting
reprinting	13	15	1058	3	reprinting
requiting	19	3	988	3	requi_ting
resetting	10	28	1629	3	re_setting
resifting	13	35	1209	3	re_sifting
resinating	11	3	1373	3	resinating
resisting	10	32	1531	3	re_sisting
resiting	9	35	2112	3	re_si_ting
resittings	11	26	455	3	re_sittings
respiting	12	19	1286	3	respi_ting
resplitting	14	4	494	3	resplitting
respotting	13	4	711	3	respotting
restituting	12	15	656	3	restituting
retinting	10	22	1525	3	re_tinting
retitling	10	3	977	3	re_titling
retting	8	34	2588	3	re___tting
retwisting	14	4	563	3	retwisting
reunifying	17	4	516	3	reunifying
revetting	13	29	1263	3	re_vetting
rewetting	13	27	1044	3	re_wetting
rewriting	13	3	1041	3	rewri_ting
telnetting	11	4	388	3	telnetting
unknotting	15	4	266	3	unknotting

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.406	440125.6
2	DLD Change Limit	140603	72	6.393	21993.3
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	6.845	26105.3