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

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

56 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
flyweights	23	5	191	(None)
flyweight	22	5	253	1	flyweight_
flights	14	33	1098	3	fl___ights
freights	15	5	585	3	f__reights
lowlights	16	4	365	3	_lowlights
playwrights	23	5	169	3	playwrights
sleights	12	27	591	3	sl__eights
unweights	16	4	320	3	_unweights
weights	14	40	955	3	___weights
alights	11	32	1143	4	al___ights
blights	13	31	1021	4	bl___ights
daylights	17	4	328	4	day_lights
deadweights	20	5	163	4	deadweights
eights	10	36	1898	4	____eights
eyesights	16	4	220	4	_eyesights
fanlights	16	4	392	4	f_anlights
fights	13	38	1655	4	f____ights
firefights	20	4	331	4	firefights
firelights	17	6	401	4	firelights
fistfights	20	5	217	4	fistfights
flashlights	21	5	188	4	flashlights
flight	13	40	1481	4	fl___ight_
flighty	17	34	743	4	fl___ighty
floodlights	19	7	159	4	floodlights
flowerets	15	4	404	4	flowe_rets
flowerpots	18	5	183	4	flowerpots
flybelts	16	8	275	4	flybe__lts
footlights	17	14	402	4	footlights
foresights	17	4	375	4	foresights
fortnights	17	5	267	4	fortnights
freight	14	4	760	4	f__reight_
frights	14	33	962	4	f___rights
heavyweights	28	6	106	4	heavyweights
heights	14	39	944	4	___heights
lights	10	45	1991	4	_l___ights
limelights	16	5	279	4	_limelights
lowlight	15	5	494	4	_lowlight_
makeweights	24	5	158	4	makeweights
millwrights	20	5	149	4	millwrights
outweighs	16	4	289	4	outweigh_s
overweights	21	5	373	4	overweights
pennyweights	24	6	127	4	pennyweights
playwright	22	5	211	4	playwright_
plights	13	29	931	4	pl___ights
preweighs	18	7	271	4	preweigh_s
reweighs	15	8	320	4	_reweigh_s
skylights	20	4	284	4	sky_lights
sleighs	11	24	567	4	sl__eigh_s
sleight	11	27	902	4	sl__eight_
slights	11	28	1072	4	sl___ights
unweight	15	4	474	4	_unweight_
weighs	13	33	887	4	___weigh_s
weight	13	39	1418	4	___weight_
weighty	17	37	623	4	___weighty
wights	13	33	1578	4	___w_ights
wrights	14	31	899	4	___wrights

Search took 10 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	161450	0.420	425454.8
2	DLD Change Limit	161450	56	8.813	18319.5
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	9.263	19290.8