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

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

52 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
plowshares	18	6	197	(None)
plowshare	17	5	178	1	plowshare_
blowhards	18	4	327	3	blow_hards
flowcharts	21	5	130	3	flowcharts
potshards	15	4	405	3	p_otshards
bloatwares	15	5	219	4	bloatwares
blowhard	17	4	373	4	blow_har_d
blowholes	17	4	447	4	blow_holes
clochards	17	4	382	4	clo_chards
closures	10	22	895	4	clo_s_ures
cowhages	17	3	611	4	_cow_hages
drawshaves	20	5	118	4	drawshaves
flowages	15	3	573	4	flow__ages
flowchart	20	5	258	4	flowchar_t
flowerages	17	4	306	4	flowerages
flowstones	16	4	345	4	flowstones
glasswares	14	4	322	4	glasswares
glossaries	11	4	451	4	glo_ssaries
nowheres	14	3	751	4	_now_heres
phosphates	20	8	716	4	phosphates
phosphores	20	7	842	4	phosphores
plashers	13	38	1345	4	pl_asher_s
plashes	12	44	1739	4	pl_ash__es
pleasures	11	4	557	4	pleas_ures
plosives	13	3	589	4	plo_s_ives
plottages	12	4	424	4	plo_ttages
ploughers	15	19	392	4	plougher_s
plowbacks	22	4	312	4	plow_backs
plowers	12	38	1224	4	plow__er_s
plowheads	18	4	256	4	plow_heads
plowlands	15	4	258	4	plow_lands
plushes	12	43	1367	4	pl_ush__es
plussages	12	4	329	4	pl_ussages
pochards	16	4	685	4	p_o_chards
poechores	16	4	795	4	p_oechores
polestars	11	5	728	4	polestar_s
polishers	14	7	760	4	polisher_s
polishes	13	7	1178	4	polish__es
postages	11	28	1532	4	p_o_stages
postures	10	3	1378	4	p_o_stures
potshard	14	4	453	4	p_otshar_d
potsherds	15	4	402	4	p_otsherds
preshapes	16	6	709	4	p_reshapes
prophages	17	4	976	4	pro_phages
prophases	16	4	1106	4	pro_phases
prostates	11	3	1442	4	pro_states
shares	9	52	3641	4	____shares
sloshes	10	38	1180	4	slo_sh__es
snowscapes	17	5	253	4	snowscapes
snowshoers	16	5	173	4	snowshoers
snowshoes	15	4	370	4	snowsh_oes
sploshes	13	3	613	4	splo_sh__es

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	161450	0.436	409841.7
2	DLD Change Limit	161450	52	9.283	17392.0
3	Display Results	52	52	0.016	3250.0
	(SQL Overall)	178691	52	9.735	18355.5