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

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

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.

90 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
proof	10	52	2153	(None)
poof	9	55	4166	1	p_oof
prof	9	61	3466	1	pr_of
proofs	11	45	1168	1	proofs
roof	7	57	3883	1	_roof
aloof	8	35	2157	2	aloof
broo	6	51	2982	2	broo_
brood	8	46	2024	2	brood
brook	11	47	1776	2	brook
broom	9	50	2221	2	broom
broos	7	51	2641	2	broos
coof	9	66	4327	2	_coof
crook	11	52	1757	2	crook
croon	7	55	2278	2	croon
drool	6	54	1610	2	drool
droop	8	58	1482	2	droop
goof	8	54	3687	2	_goof
groom	8	53	1798	2	groom
hoof	10	60	3658	2	_hoof
kloof	12	38	1213	2	kloof
kroon	9	45	1448	2	kroon
loof	7	81	4105	2	_loof
poo	5	77	5711	2	p_oo_
pood	7	59	3432	2	p_ood
poofs	10	52	2279	2	p_oofs
poofy	13	62	1327	2	p_oofy
pooh	9	60	2738	2	p_ooh
pool	6	58	3595	2	p_ool
poon	6	73	4126	2	p_oon
poop	8	65	3281	2	p_oop
poor	6	56	3022	2	p_oor
poos	6	59	4911	2	p_oos
pouf	9	57	3264	2	p_ouf
prao	6	62	2902	2	prao_
praos	7	49	2356	2	praos
preop	9	47	1587	2	preop
prion	7	51	1999	2	prion
prior	7	43	1617	2	prior
pro	5	58	3726	2	pr_o_
proa	6	62	2996	2	pr_oa
proas	7	50	2880	2	proas
probe	9	43	2081	2	probe
prod	7	61	2950	2	pr_od
prods	8	55	2355	2	prods
proem	9	48	1827	2	proem
profs	10	51	2089	2	profs
prog	7	57	2900	2	pr_og
progs	8	66	2415	2	progs
prole	7	45	2779	2	prole
prolog	9	42	1297	2	prolog
prom	8	76	3169	2	pr_om
promo	9	56	1999	2	promo
promos	10	51	1642	2	promos
proms	9	54	2640	2	proms
prone	7	53	3262	2	prone
prong	8	52	1811	2	prong
proofed	13	13	872	2	proofed
proofer	12	14	910	2	proofer
prop	8	59	3281	2	pr_op
props	9	57	2688	2	props
pros	6	57	4278	2	pr_os
prose	7	58	3512	2	prose
proso	7	72	2241	2	proso
prosos	8	57	1855	2	prosos
pross	7	65	2940	2	pross
prost	7	54	3410	2	prost
prosy	10	63	1925	2	prosy
proton	8	43	1889	2	proton
proud	8	46	1548	2	proud
prove	10	48	2319	2	prove
prow	9	70	3038	2	pr_ow
prowl	10	56	1512	2	prowl
prows	10	63	2701	2	prows
proxy	17	50	1101	2	proxy
reproof	12	3	878	2	reproof
reroof	9	3	1500	2	reroof
rolf	7	51	3487	2	_rolf
rood	5	67	3300	2	_rood
roofs	8	53	2115	2	_roofs
rook	8	55	3203	2	_rook
room	6	62	3508	2	_room
root	4	56	5592	2	_root
spoof	10	50	1901	2	spoof
troop	7	64	1753	2	troop
trooz	14	50	1615	2	trooz
unroof	9	4	1019	2	unroof
uproot	8	3	1412	2	uproot
vroom	10	53	1247	2	vroom
whoof	14	46	1269	2	whoof
woof	10	65	3242	2	_woof

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	90	1.800	29888.9
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	1.923	92923.0