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

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

69 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
redistricts	14	5	366	(None)
redistrict	13	5	570	1	redistrict_
districts	12	4	893	2	__districts
redistricted	16	5	296	2	redistricted
restricts	11	3	882	2	re__stricts
distracts	12	4	928	3	__distracts
district	11	4	1387	3	__district_
editrices	12	4	532	3	_edi_trices
mediatrices	16	5	338	3	mediatrices
pediatrics	15	4	419	3	pediatric_s
pediatrists	14	5	406	3	pediatrists
redirects	12	12	510	3	redi__rects
redistills	11	4	316	3	redist_ills
redistribute	15	13	301	3	redistribute
redistributes	16	12	285	3	redistributes
redistricting	17	5	378	3	redistricting
registrants	12	5	306	3	registrants
registries	11	4	649	3	registri_es
restrict	10	3	1363	3	re__strict_
subdistricts	17	6	170	3	subdistricts
abstricts	13	5	518	4	__abstricts
astricts	10	4	946	4	___astricts
constricts	14	7	773	4	_constricts
destructs	12	4	577	4	__destructs
distichs	14	4	763	4	__dist_ichs
distract	11	3	1302	4	__distract_
distraints	11	6	687	4	__distraints
districted	14	4	822	4	__districted
distrusts	10	4	652	4	__distrusts
editrixes	17	4	381	4	_edi_trixes
ekistics	14	8	570	4	_ekist_ic_s
eristics	10	6	1019	4	_erist_ic_s
geriatrics	13	4	342	4	geriatric_s
hemistichs	20	5	338	4	hemist_ichs
heritrices	15	5	530	4	heri_trices
mediatrixes	21	5	259	4	mediatrixes
paediatrics	16	5	263	4	paediatric_s
pedestrians	14	5	381	4	pedestrians
pediatric	14	4	527	4	pediatric__
pediatrist	13	6	594	4	pediatrist_
pedicurists	16	5	296	4	pedicurists
peritrichs	17	5	338	4	peri_trichs
podiatrists	14	5	337	4	podiatrists
reconstructs	16	5	424	4	reconstructs
rectrices	13	3	887	4	re__ctrices
redbricks	18	4	230	4	red__bricks
redescribes	16	5	285	4	redescribes
redirect	11	14	799	4	redi__rect_
rediscounts	14	5	228	4	rediscounts
redistill	10	4	450	4	redist_i_ll
redistributed	17	12	267	4	redistributed
redivorces	16	4	296	4	redivor_ces
redshifts	16	4	257	4	red_s_hifts
redshirts	13	4	290	4	red_s_hirts
redstarts	10	4	424	4	red_st_arts
registrant	11	5	476	4	registrant_
registrars	11	5	239	4	registr_ars
reindicts	12	7	476	4	re_i_ndicts
rescripts	13	7	457	4	re__scripts
resistances	13	4	537	4	resistances
resistants	10	4	552	4	resist_ants
restraints	10	5	660	4	re__straints
restricted	13	4	830	4	re__stricted
restrikes	13	3	941	4	re__strikes
restrings	10	15	929	4	re__strings
restrives	12	3	1066	4	re__strives
retracts	10	11	1131	4	re___tracts
revisits	11	3	742	4	revis__i_ts
subdistrict	16	5	270	4	subdistrict_

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.436	409841.7
2	DLD Change Limit	148819	69	9.233	16118.2
3	Display Results	69	69	0.046	1500.0
	(SQL Overall)	178691	69	9.715	18393.3