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

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

54 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
valiantnesses	16	5	272	(None)
pliantnesses	14	4	445	2	_pliantnesses
vacantnesses	17	4	296	2	va_cantnesses
valiantness	14	5	231	2	valiantne_s_s
aliennesses	11	4	586	3	_alien_nesses
faintnesses	14	4	714	3	fa_i_ntnesses
militantnesses	16	6	186	3	militantnesses
vainnesses	13	3	734	3	va_i_n_nesses
validnesses	15	7	602	3	vali__dnesses
alertnesses	11	4	722	4	_al_ertnesses
alikenesses	15	4	719	4	_ali_kenesses
alivenesses	14	4	885	4	_ali_venesses
alonenesses	11	4	721	4	_al_onenesses
ancientnesses	15	5	328	4	ancientnesses
apartnesses	13	4	682	4	_a_partnesses
aviatresses	14	8	300	4	_avia_tresses
blandnesses	14	4	662	4	_bl_andnesses
blanknesses	17	4	493	4	_bl_anknesses
blindnesses	14	4	618	4	_bli_ndnesses
bluntnesses	13	4	538	4	_bl_untnesses
cleannesses	13	13	582	4	_clean_nesses
daintinesses	13	4	624	4	da_i_ntinesses
daringnesses	14	6	483	4	dari_ngnesses
darlingnesses	15	6	304	4	darli_ngnesses
distantnesses	14	5	382	4	distantnesses
flatnesses	13	3	776	4	_fl_a_tnesses
flintinesses	15	4	632	4	_fli_ntinesses
gauntnesses	12	4	517	4	ga__untnesses
giantesses	11	4	351	4	__giant_esses
instantnesses	13	5	406	4	instantnesses
lanknesses	14	3	750	4	__l_anknesses
leannesses	10	10	834	4	__lean_nesses
licitnesses	13	4	639	4	__licitnesses
lightnesses	15	4	614	4	__lightnesses
piquantnesses	24	5	202	4	piquantnesses
plainnesses	13	5	620	4	plai_n_nesses
planenesses	13	4	903	4	_pl_anenesses
pliantness	12	6	364	4	_pliantne_s_s
quaintnesses	21	4	379	4	quai_ntnesses
raininesses	11	3	1047	4	ra_i_ninesses
saltnesses	10	3	1016	4	sal___tnesses
scantnesses	13	7	653	4	__scantnesses
silentnesses	12	7	544	4	sil_entnesses
slightnesses	16	5	462	4	_slightnesses
stalwartnesses	17	5	129	4	stalwartnesses
tacitnesses	13	3	632	4	taci__tnesses
vacantness	15	6	251	4	va_cantne_s_s
valuablenesses	19	5	467	4	valuablenesses
vapidnesses	17	7	489	4	vapi__dnesses
variablenesses	19	6	545	4	variablenesses
variousnesses	16	4	863	4	variousnesses
vastnesses	13	12	819	4	v___astnesses
venialnesses	15	5	568	4	venia_lnesses
villainesses	15	4	350	4	villa_inesses

Search took 7 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.126	1418182.5
2	DLD Change Limit	95024	54	6.390	14870.7
3	Display Results	54	54	0.046	1173.9
	(SQL Overall)	178691	54	6.562	27231.2