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

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

65 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
crispinesses	16	4	500	(None)
crispnesses	15	4	594	1	crisp_nesses
creepinesses	16	4	525	2	creepinesses
crispiness	14	4	479	2	crispine_s_s
crustinesses	14	13	763	2	crustinesses
friskinesses	19	4	477	2	friskinesses
grislinesses	13	4	582	2	grislinesses
prissinesses	13	5	595	2	prissinesses
raspinesses	13	3	801	2	_raspinesses
riskinesses	15	3	783	2	_riskinesses
wispinesses	16	3	627	2	_wispinesses
artsinesses	11	3	871	3	arts_inesses
brassinesses	13	4	606	3	brassinesses
brininesses	13	3	898	3	bri_ninesses
brisknesses	17	4	558	3	bris_knesses
campinesses	17	3	711	3	c_ampinesses
chillinesses	17	4	498	3	chillinesses
choppinesses	21	4	335	3	choppinesses
classinesses	13	6	611	3	classinesses
cosinesses	12	10	1282	3	c_os_inesses
craftinesses	17	4	638	3	craftinesses
cragginesses	16	4	450	3	cragginesses
crankinesses	18	4	614	3	crankinesses
crassnesses	12	4	665	3	cras_snesses
crazinesses	22	3	793	3	cr_azinesses
creakinesses	18	4	599	3	creakinesses
creaminesses	16	4	613	3	creaminesses
crispness	13	4	530	3	crisp_ne_s_s
crossnesses	12	4	712	3	cros_snesses
crumminesses	18	4	365	3	crumminesses
cushinesses	16	12	741	3	c_ushinesses
dippinesses	16	3	524	3	_dippinesses
dressinesses	12	4	552	3	dressinesses
feistinesses	15	5	589	3	feistinesses
fishinesses	17	10	724	3	_fishinesses
frizzinesses	23	4	293	3	frizzinesses
frostinesses	15	4	653	3	frostinesses
grapinesses	14	3	857	3	gr_apinesses
griminesses	14	16	755	3	gri_minesses
gristlinesses	14	4	399	3	gristlinesses
grittinesses	13	4	584	3	grittinesses
grumpinesses	17	4	366	3	grumpinesses
hippinesses	18	4	549	3	_hippinesses
lippinesses	15	3	551	3	_lippinesses
mistinesses	13	13	1062	3	_mistinesses
nippinesses	15	4	506	3	_nippinesses
noisinesses	11	3	948	3	nois_inesses
pipinesses	14	4	860	3	_pi_pinesses
preppinesses	15	4	488	3	preppinesses
prosinesses	13	3	1085	3	pros_inesses
riminesses	12	12	1141	3	_ri_minesses
ripenesses	12	3	1037	3	_ri_penesses
ritzinesses	20	9	674	3	_ritzinesses
ropinesses	12	13	1102	3	_r_opinesses
rosinesses	10	12	1314	3	_ros_inesses
rustinesses	11	9	1155	3	_rustinesses
scrappinesses	19	5	229	3	scrappinesses
sissinesses	9	11	831	3	_sissinesses
skimpinesses	20	4	318	3	skimpinesses
tipsinesses	13	3	636	3	_tipsinesses
trashinesses	15	4	611	3	trashinesses
trickinesses	18	4	522	3	trickinesses
trustinesses	12	11	698	3	trustinesses
waspinesses	16	3	670	3	_waspinesses
wimpinesses	18	3	563	3	_wimpinesses

Search took 4 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	95024	0.106	1685764.2
2	DLD Change Limit	95024	65	3.393	28005.9
3	Display Results	65	65	0.046	1413.0
	(SQL Overall)	178691	65	3.545	50406.5