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

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

68 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
tracklayers	20	5	182	(None)
tracklayer	19	4	249	1	tracklayer_
bricklayers	22	5	164	2	bricklayers
bricklayer	21	5	172	3	bricklayer_
tacklers	14	30	1077	3	t_ackl__ers
trackages	16	4	534	3	track_age_s
trackers	14	35	1285	3	track___ers
tracklaying	21	5	239	3	tracklaying
tracklayings	22	5	113	3	tracklayings
trackless	15	24	672	3	trackl__ess
trackwalkers	20	5	154	3	trackwalkers
trackways	21	10	343	3	trackway__s
trucklers	15	29	558	3	truckl__ers
allayers	11	15	663	4	__a_llayers
backlashers	22	12	363	4	_backlashers
backwaters	21	9	516	4	_backwaters
blackwaters	22	10	314	4	blackwaters
cacklers	16	37	1070	4	_cackl__ers
cardplayers	19	5	166	4	cardplayers
crackers	16	41	1172	4	crack___ers
crackles	16	41	1127	4	crackl__e_s
cracklier	17	4	482	4	crackl_ier_
grackles	15	30	918	4	grackl__e_s
hacklers	17	37	1030	4	_hackl__ers
manslayers	15	4	268	4	_manslayers
packagers	18	14	468	4	_pack_agers
rackers	13	43	2045	4	_rack___ers
racketeers	16	15	363	4	_racketeers
ratepayers	15	4	197	4	_ratepayers
shacklers	18	33	603	4	shackl__ers
tackers	13	43	1962	4	t_ack___ers
tackifiers	19	4	293	4	t_ackifiers
tackler	13	40	1332	4	t_ackl__er_
tackles	13	38	1652	4	t_ackl__e_s
tackless	14	41	948	4	t_ackl__ess
taxpayers	21	4	189	4	t_a_xpayers
ticklers	14	33	930	4	t_ickl__ers
traceless	11	22	864	4	tracel__ess
tracers	9	49	1784	4	trac____ers
tracheates	15	4	792	4	tracheate_s
trachles	13	3	1175	4	trachl__e_s
trackage	15	4	565	4	track_age__
trackballs	18	6	329	4	trackba_lls
tracker	13	35	1517	4	track___er_
trackpads	18	4	304	4	trackpa__ds
tracksides	17	4	416	4	trackside_s
trackwalker	19	6	197	4	trackwalker_
trackway	20	11	378	4	trackway___
tractates	11	5	976	4	trac_tate_s
trailblazers	23	5	123	4	trailblazers
trailers	8	29	1292	4	tra_il__ers
tramplers	13	30	588	4	trampl__ers
translates	10	4	1170	4	translate_s
translators	11	5	644	4	translators
travelers	12	26	677	4	travel__ers
travellers	13	6	466	4	travel_lers
trawlers	11	33	1020	4	tra_wl__ers
trickers	14	38	1281	4	trick___ers
trickles	14	30	1376	4	trickl__e_s
tricklier	15	25	682	4	trickl_ier_
tricksters	16	26	476	4	trick_sters
truckages	16	4	352	4	truck_age_s
truckers	14	27	901	4	truck___ers
truckler	14	29	745	4	truckl__er_
truckles	14	31	938	4	truckl__e_s
trucklines	16	4	429	4	truckline_s
truckmasters	20	5	177	4	truckmasters
waylayers	18	4	294	4	_wa_ylayers

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.406	440125.6
2	DLD Change Limit	148819	68	8.283	17966.8
3	Display Results	68	68	0.046	1478.3
	(SQL Overall)	178691	68	8.735	20456.9