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

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

82 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
porosity	13	4	859	(None)
morosity	13	4	729	1	morosity
torosity	11	4	724	1	torosity
jocosity	20	4	434	2	jocosity
moronity	13	4	733	2	moronity
nodosity	12	5	492	2	nodosity
pilosity	13	6	632	2	pilosity
piosity	12	6	864	2	p_iosity
pomposity	18	4	465	2	pomposity
probity	14	29	968	2	p_robity
prosily	12	6	1163	2	p_rosily
prosit	8	51	2459	2	p_rosit_
serosity	11	4	878	2	serosity
sorority	11	4	690	2	sorority
atrocity	13	4	721	3	atrocity
cariosity	14	4	621	3	cariosity
curiosity	14	4	454	3	curiosity
ferocity	16	4	599	3	ferocity
fortuity	14	6	557	3	fortuity
frosty	12	47	1063	3	_fros_ty
globosity	15	4	273	3	globosity
gulosity	12	4	444	3	gulosity
horsily	13	3	884	3	hor_sily
jarosite	15	4	838	3	jarosite
lanosity	11	4	635	3	lanosity
morality	13	11	1033	3	morality
morosely	13	4	571	3	morosely
mucosity	15	4	498	3	mucosity
nervosity	15	4	328	3	nervosity
obesity	12	7	565	3	_obesity
opposite	12	4	713	3	opposite
orality	10	11	1168	3	_orality
otiosity	11	5	576	3	otiosity
parasite	10	3	1484	3	parasite
parity	11	47	1987	3	par__ity
plumosity	16	4	299	3	plumosity
pocosin	11	6	964	3	pocosi_n
pocosins	12	5	895	3	pocosins
polarity	13	13	1040	3	polarity
polity	11	30	1586	3	p__olity
poloist	9	10	1632	3	poloist_
poloists	10	9	1052	3	poloists
poortith	13	5	536	3	poortith
porose	8	48	1874	3	poros__e
porosities	12	4	1148	3	porosities
porously	13	4	775	3	porously
portside	11	3	816	3	portside
posit	7	58	3333	3	p__osit_
posits	8	57	1871	3	p__osits
priority	13	4	744	3	priority
privity	15	26	831	3	p_rivity
probit	10	32	1835	3	p_robit_
probits	11	27	1257	3	p_robits
prodigy	14	3	557	3	p_rodigy
profit	11	30	1627	3	p_rofit_
profits	12	29	1124	3	p_rofits
propositi	13	6	847	3	propositi
prosier	9	38	1748	3	p_rosier
prosing	10	33	1938	3	p_rosing
prosody	13	3	643	3	p_rosody
prost	7	54	3410	3	p_ros_t_
prostie	9	16	1774	3	p_rostie
prosy	10	63	1925	3	p_ros__y
purity	11	41	1491	3	pur__ity
pursily	12	3	821	3	pur_sily
pyrosis	12	4	1165	3	pyrosi_s
ramosity	13	4	589	3	ramosity
rimosity	13	4	571	3	rimosity
rosily	9	39	1471	3	__rosily
rosiny	9	44	1453	3	__rosiny
rugosity	12	4	373	3	rugosity
sonority	11	4	853	3	sonority
sorosis	7	26	1197	3	sorosi_s
sparsity	13	4	546	3	spar_sity
spinosity	14	4	424	3	spinosity
tortuosity	13	5	263	3	tortuosity
varsity	13	5	667	3	var_sity
venosity	14	4	602	3	venosity
verbosity	17	4	406	3	verbosity
vinosity	14	4	573	3	vinosity
voracity	16	4	553	3	voracity
zygosity	24	4	298	3	zygosity

Search took 8 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	146162	0.153	1167915.0
2	DLD Change Limit	146162	82	7.563	19325.9
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	7.749	23059.9