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

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

55 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
trollers	8	32	1121	(None)
rollers	7	31	1747	1	_rollers
strollers	9	3	754	1	strollers
tollers	7	32	1746	1	t_ollers
trillers	8	36	1349	1	trillers
troller	7	39	1317	1	troller_
trolleys	11	31	569	1	trolleys
broilers	10	32	1009	2	broilers
carollers	11	3	770	2	carollers
crullers	10	4	730	2	crullers
drillers	9	42	972	2	drillers
droller	8	41	1028	2	droller_
drollery	12	31	479	2	drollery
enrollers	9	7	617	2	enrollers
frillers	11	34	987	2	frillers
grillers	9	38	1081	2	grillers
growlers	12	32	709	2	growlers
hollers	10	38	1823	2	_hollers
knollers	12	25	513	2	knollers
krullers	12	3	413	2	krullers
lollers	7	27	1379	2	_lollers
patrollers	12	4	481	2	patrollers
pollers	9	34	2002	2	_pollers
prowlers	13	32	893	2	prowlers
rerollers	9	20	712	2	rerollers
rolfers	10	40	1181	2	_rolfers
roller	6	39	1979	2	_roller_
stroller	8	4	817	2	stroller_
tellers	7	37	1759	2	t_ellers
thrillers	12	4	447	2	thrillers
tillers	7	34	1874	2	t_illers
toilers	7	41	1626	2	t_oilers
toller	6	38	1944	2	t_oller_
toolers	7	44	1650	2	t_oolers
toolless	8	3	634	2	toolless
tootlers	8	28	950	2	tootlers
trailers	8	29	1292	2	trailers
trawlers	11	33	1020	2	trawlers
triflers	11	31	1021	2	triflers
triller	7	42	1589	2	triller_
troffers	14	12	543	2	troffers
trolled	8	43	1226	2	trolle_d
trolley	10	32	875	2	trolle_y
trollies	8	3	1023	2	trollies
trollops	10	4	481	2	trollops
trolls	6	46	1394	2	troll__s
troopers	10	28	944	2	troopers
trotters	8	33	1024	2	trotters
troublers	11	3	500	2	troublers
troupers	10	35	944	2	troupers
trousers	8	39	1063	2	trousers
trovers	10	37	1332	2	tro_vers
trowelers	12	10	526	2	trowelers
trowellers	13	4	366	2	trowellers
trowsers	11	42	800	2	trowsers

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.140	1276364.3
2	DLD Change Limit	121059	55	3.940	30725.6
3	Display Results	55	55	0.013	4230.8
	(SQL Overall)	178691	55	4.093	43657.7