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

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

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
prowlers	13	32	893	(None)
growlers	12	32	709	1	growlers
prowler	12	33	1001	1	prowler_
bowlers	12	37	1578	2	_bowlers
brawlers	13	40	864	2	brawlers
broilers	10	32	1009	2	broilers
browless	13	4	665	2	browless
browsers	13	44	920	2	browsers
crawlers	13	30	900	2	crawlers
crowders	14	39	880	2	crowders
crowers	12	46	1489	2	crow_ers
crowners	13	37	1074	2	crowners
drawlers	12	30	731	2	drawlers
drowners	12	42	827	2	drowners
fowlers	13	34	1120	2	_fowlers
frowners	14	37	793	2	frowners
growers	11	36	1272	2	grow_ers
growler	11	31	897	2	growler_
howlers	13	33	1235	2	_howlers
peoplers	12	3	715	2	peoplers
plowers	12	38	1224	2	plow_ers
polers	8	42	2564	2	p_o_lers
pollers	9	34	2002	2	p_ollers
poolers	9	42	1742	2	p_oolers
powders	13	41	1155	2	p_owders
powers	11	38	2232	2	p_ow_ers
powters	12	40	1566	2	p_owters
prawners	13	4	600	2	prawners
probers	11	35	1458	2	pro_bers
problems	14	3	434	2	problems
prodders	12	3	746	2	prodders
proffers	16	12	659	2	proffers
profilers	14	23	629	2	profilers
proggers	12	25	816	2	proggers
prolegs	10	37	999	2	pro_legs
proles	8	46	2720	2	pro_le_s
proofers	13	11	836	2	proofers
propers	11	36	1903	2	pro_pers
prosers	9	42	1964	2	pro_sers
prospers	12	30	1226	2	prospers
provers	12	38	1779	2	pro_vers
prower	11	42	1812	2	prow_er_
prowess	12	3	790	2	prow_ess
prowled	13	30	990	2	prowle_d
prowls	11	55	1108	2	prowl__s
rollers	7	31	1747	2	_rollers
rowers	9	49	2457	2	_row_ers
scowlers	13	25	735	2	scowlers
sprawlers	14	3	389	2	sprawlers
trawlers	11	33	1020	2	trawlers
trollers	8	32	1121	2	trollers
trowelers	12	10	526	2	trowelers
trowsers	11	42	800	2	trowsers
yowlers	13	32	892	2	_yowlers

Search took 4 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.140	1276364.3
2	DLD Change Limit	121059	54	3.220	37596.0
3	Display Results	54	54	0.013	4153.8
	(SQL Overall)	178691	54	3.373	52976.9