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

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

75 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
cunningness	14	5	293	(None)
cunningest	13	4	335	2	cunning_est
cunningnesses	16	7	324	2	cunningnesses
bindingness	15	5	320	3	bindingness
canniness	11	3	864	3	canni__ness
cunninger	12	4	276	3	cunning_e_r
cunnings	11	35	734	3	cunning___s
funniness	12	25	653	3	funni__ness
runniness	9	24	710	3	runni__ness
sunniness	9	24	794	3	sunni__ness
unkindness	15	4	413	3	_unkindness
amusingness	14	5	252	4	amusingness
bonniness	11	3	673	4	bonni__ness
boringness	13	4	467	4	_boringness
candidness	14	4	477	4	candi_dness
canninesses	13	6	885	4	canninesses
cannings	11	37	1033	4	canning___s
clannishness	17	5	281	4	clannishness
conciseness	15	4	666	4	conciseness
confidingness	20	10	182	4	confidingness
consignees	13	4	522	4	consi_gnees
consigners	13	4	641	4	consi_gners
contingents	14	4	637	4	contingents
convincingness	22	7	134	4	convincingness
corniness	11	26	1118	4	corni__ness
cultishness	16	4	433	4	cultishness
cunnilingus	14	5	149	4	cunnilingus
cunnilinguses	16	6	98	4	cunnilinguses
cunning	10	42	1462	4	cunning____
cunningly	15	4	553	4	cunning__ly
curliness	11	3	855	4	curli__ness
currentness	13	5	282	4	currentness
cursiveness	16	4	707	4	cursiveness
cushiness	14	19	718	4	cushi__ness
daringness	12	4	474	4	_daringness
darlingness	13	7	326	4	darlingness
donnishness	15	4	389	4	donnishness
feelingness	15	5	348	4	feelingness
fittingness	15	5	317	4	fittingness
funkiness	16	22	687	4	funki__ness
funninesses	14	10	687	4	funninesses
genuineness	12	5	384	4	genuineness
glaringness	13	4	326	4	glaringness
gunnings	10	34	673	4	gunning___s
knowingness	19	5	217	4	knowingness
lastingness	12	4	400	4	lastingness
liltingness	12	5	304	4	liltingness
livingness	14	4	334	4	_livingness
lovingness	14	4	318	4	_lovingness
mannishness	16	4	397	4	mannishness
meaningless	14	5	210	4	meaningless
mundaneness	14	5	344	4	mundaneness
nothingness	15	5	292	4	nothingness
ongoingness	13	7	304	4	ongoingness
outgoingness	14	5	180	4	outgoingness
puniness	10	16	1027	4	pu_ni__ness
punkiness	15	22	698	4	punki__ness
quaintness	19	4	320	4	qu_aintness
runninesses	11	13	769	4	runninesses
runnings	9	32	691	4	running___s
runtiness	9	24	1039	4	runti__ness
sunninesses	11	14	838	4	sunninesses
supineness	12	4	587	4	su_pineness
teemingness	14	5	316	4	teemingness
thingness	13	5	489	4	__thingness
thinkingness	20	5	177	4	thinkingness
tinniness	9	3	609	4	tinni__ness
trustingness	13	5	246	4	trustingness
unfitness	12	4	484	4	_unfi_tness
unhinges	12	26	672	4	_unhing_e_s
unlikeness	14	4	468	4	_unlikeness
unmingles	12	4	398	4	_unmingle_s
unripeness	12	4	524	4	_unripeness
untidiness	11	5	567	4	_untidiness
willingness	15	5	304	4	willingness

Search took 9 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	148819	0.423	422437.4
2	DLD Change Limit	148819	75	8.093	18388.6
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	8.549	20902.0