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

Here are the results of your fuzzy-string dictionary search for “pranking” with Change Limit: [1] [2] [3]

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.

63 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
pranking	15	38	1338	(None)
cranking	15	46	1307	1	cranking
franking	16	43	1086	1	franking
planking	15	35	1301	1	planking
prancing	13	26	1216	1	prancing
pranging	12	30	1272	1	pranging
prinking	15	32	1245	1	prinking
ranking	12	43	2088	1	_ranking
banking	14	46	2135	2	_banking
blanking	15	44	1193	2	blanking
braking	14	39	1771	2	bra_king
branding	12	25	1368	2	branding
branning	11	29	1109	2	branning
clanking	15	43	1306	2	clanking
cracking	17	40	1390	2	cracking
craning	10	36	2030	2	cran_ing
crankling	16	14	729	2	crankling
drinking	14	30	891	2	drinking
flanking	16	42	1108	2	flanking
granting	10	35	1452	2	granting
hanking	15	46	1910	2	_hanking
packing	16	44	2072	2	p_acking
paiking	14	38	1481	2	p_aiking
panging	11	33	1911	2	p_anging
panning	10	40	1939	2	p_anning
panting	10	40	2542	2	p_anting
parking	14	34	2304	2	p_arking
peaking	14	43	1769	2	pea_king
pinking	14	39	1894	2	p_inking
planing	10	34	1825	2	plan_ing
plankings	16	32	611	2	plankings
planning	11	36	1022	2	planning
planting	11	35	1538	2	planting
plinking	15	36	1124	2	plinking
plonking	15	35	856	2	plonking
plunking	15	32	848	2	plunking
praising	11	32	1456	2	praising
prankish	17	3	702	2	prankish
prating	10	34	2445	2	pra_ting
prawning	14	4	696	2	prawning
praying	13	37	1732	2	pra_ying
pricking	17	32	1260	2	pricking
printing	11	32	1608	2	printing
pronging	12	35	1184	2	pronging
pruning	10	3	1173	2	prun_ing
racking	14	43	2366	2	_racking
raking	11	47	2842	2	_ra_king
ranging	9	41	2026	2	_ranging
rankings	13	38	917	2	_rankings
rankling	13	26	1011	2	_rankling
ranting	8	40	2541	2	_ranting
shanking	16	36	1228	2	shanking
skanking	12	28	874	2	skanking
spanking	15	39	1197	2	spanking
swanking	16	39	996	2	swanking
tanking	12	39	1879	2	_tanking
thanking	16	40	952	2	thanking
tracking	15	37	1546	2	tracking
traiking	13	25	1197	2	traiking
trancing	11	28	1202	2	trancing
wanking	15	42	1678	2	_wanking
wracking	18	34	996	2	wracking
yanking	15	45	1246	2	_yanking

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	121059	0.390	458182.1
2	DLD Change Limit	121059	63	3.843	31501.2
3	Display Results	63	63	0.016	3937.5
	(SQL Overall)	178691	63	4.249	42054.8