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

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

64 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
purslane	10	4	578	(None)
purslanes	11	4	552	1	purslanes
purline	9	35	1653	2	pur_line
pursuance	13	4	409	2	pursuance
pursuant	10	4	656	2	pursuant
airplane	10	6	779	3	airplane
bursae	8	45	1560	3	burs_a_e
bursate	9	41	1120	3	burs_ate
burstone	10	5	713	3	burstone
furane	9	40	1549	3	fur__ane
lurdane	8	3	598	3	lur_dane
nursling	9	9	760	3	nursling
paravane	13	4	810	3	paravane
parkland	15	4	537	3	parkland
parlance	12	4	872	3	par_lance
parlante	10	3	969	3	par_lante
perilune	10	4	698	3	perilune
personae	10	24	1055	3	personae
persuade	11	4	585	3	persuade
plane	7	49	2914	3	p___lane
praline	9	30	1974	3	p_raline
prelate	9	5	1969	3	p_relate
pristane	10	3	1034	3	pristane
profane	12	21	1186	3	p_rofane
prolan	8	4	1469	3	p_rolan_
prolans	9	3	1427	3	p_rolans
prolate	9	4	1979	3	p_rolate
proline	9	23	2159	3	p_roline
propane	11	27	1615	3	p_ropane
puisne	8	5	635	3	puis__ne
puissance	13	4	378	3	puissance
puissant	10	10	539	3	puissant
pulsant	9	3	1056	3	puls_ant
pulsate	9	5	1023	3	puls_ate
pupilage	13	4	377	3	pupilage
purana	8	7	1293	3	pur__ana
purblind	13	4	516	3	purblind
purchase	15	4	529	3	purchase
purfle	11	25	1118	3	purfl__e
purfling	14	6	776	3	purfling
purine	8	53	2189	3	pur__ine
puritan	9	3	928	3	puritan_
puritans	10	3	763	3	puritans
purlin	8	36	1586	3	pur_lin_
purlines	10	35	1405	3	pur_lines
purling	10	36	2029	3	pur_ling
purlins	9	34	1542	3	pur_lins
purple	10	27	1268	3	purpl__e
purpling	13	6	854	3	purpling
purse	7	60	2889	3	purs___e
purselike	15	4	437	3	purselike
pursing	10	37	1555	3	purs_ing
pursuable	13	4	469	3	pursuable
pursuances	14	4	345	3	pursuances
pursue	8	45	1225	3	purs__ue
pursuing	11	4	623	3	pursuing
purulence	13	4	503	3	purulence
purulent	10	4	761	3	purulent
puslike	13	4	756	3	pu_slike
pusslike	14	3	403	3	pusslike
urbane	8	22	1138	3	_ur_bane
ursae	5	52	1445	3	_urs_a_e
ursine	6	41	1412	3	_urs_ine
warplane	13	4	598	3	warplane

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	64	6.810	21462.8
3	Display Results	64	64	0.016	4000.0
	(SQL Overall)	178691	64	7.249	24650.4