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

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

60 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
snappinesses	16	8	432	(None)
nappinesses	15	5	592	1	_nappinesses
sappinesses	15	6	756	1	s_appinesses
happinesses	18	7	616	2	_happinesses
nippinesses	15	4	506	2	_nippinesses
scrappinesses	19	5	229	2	scrappinesses
sloppinesses	16	4	405	2	sloppinesses
snakinesses	15	3	855	2	sna_kinesses
snappiness	14	4	383	2	snappine_s_s
snappishnesses	20	5	226	2	snappishnesses
soapinesses	13	3	971	2	soa_pinesses
soppinesses	15	6	684	2	s_oppinesses
swampinesses	19	4	371	2	swampinesses
unhappinesses	20	5	248	2	unhappinesses
campinesses	17	3	711	3	_campinesses
choppinesses	21	4	335	3	choppinesses
dippinesses	16	3	524	3	_dippinesses
floppinesses	19	4	295	3	floppinesses
grapinesses	14	3	858	3	gra_pinesses
hippinesses	18	4	549	3	_hippinesses
inaptnesses	13	8	563	3	ina_ptnesses
lippinesses	15	3	551	3	_lippinesses
nappiness	13	3	523	3	_nappine_s_s
nastinesses	11	11	1074	3	_nastinesses
nattinesses	11	11	932	3	_nattinesses
peppinesses	14	3	531	3	_peppinesses
preppinesses	15	4	488	3	preppinesses
raspinesses	13	3	801	3	_raspinesses
saltinesses	11	3	1145	3	s_altinesses
sandinesses	12	9	1139	3	s_andinesses
sappiness	13	3	744	3	s_appine_s_s
sassinesses	9	9	932	3	s_assinesses
saucinesses	13	3	898	3	s_aucinesses
savvinesses	17	3	566	3	s_avvinesses
scalinesses	13	3	932	3	sca_linesses
scantinesses	14	3	731	3	scantinesses
scarinesses	13	3	990	3	sca_rinesses
seaminesses	13	3	1075	3	sea_minesses
shabbinesses	19	5	343	3	shabbinesses
shadinesses	15	3	864	3	sha_dinesses
shagginesses	17	4	396	3	shagginesses
shakinesses	18	3	761	3	sha_kinesses
shapelinesses	18	4	341	3	shapelinesses
sharpnesses	16	4	523	3	sharp_nesses
skimpinesses	20	4	318	3	skimpinesses
slanginesses	13	4	696	3	slanginesses
slatinesses	11	3	1163	3	sla_tinesses
sleepinesses	14	4	567	3	sleepinesses
smarminesses	16	4	510	3	smarminesses
sneakinesses	16	4	590	3	sneakinesses
sniffinesses	18	4	369	3	sniffinesses
snootinesses	12	6	580	3	snootinesses
snottinesses	12	5	584	3	snottinesses
snowinesses	14	3	641	3	sn_owinesses
snubbinesses	16	4	339	3	snubbinesses
spacinesses	15	3	810	3	spa_cinesses
staginesses	12	3	846	3	sta_ginesses
swankinesses	19	4	478	3	swankinesses
unaptnesses	13	9	552	3	una_ptnesses
waspinesses	16	3	670	3	_waspinesses

Search took 5 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.406	440125.6
2	DLD Change Limit	95024	60	4.360	21794.5
3	Display Results	60	60	0.046	1304.3
	(SQL Overall)	178691	60	4.812	37134.5