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

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

72 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
mullets	9	36	1478	(None)
bullets	9	35	1639	1	bullets
cullets	9	40	1561	1	cullets
gullets	8	40	1371	1	gullets
mallets	9	33	1849	1	mallets
millets	9	42	1684	1	millets
mullens	9	36	1131	1	mullens
mullers	9	32	1730	1	mullers
mullet	8	41	2682	1	mullet_
mulleys	12	29	920	1	mulleys
pullets	9	40	1516	1	pullets
amulets	9	3	992	2	amu_lets
auklets	11	29	857	2	auklets
ballets	9	37	1951	2	ballets
billets	9	45	1615	2	billets
bulblets	12	5	535	2	bulblets
bullet	8	45	2861	2	bullet_
callets	9	38	2170	2	callets
collets	9	35	1790	2	collets
culets	8	55	1851	2	cu_lets
cullers	9	34	1884	2	cullers
cullet	8	47	2731	2	cullet_
cutlets	9	41	1365	2	cutlets
dulcets	10	4	628	2	dulcets
dullest	8	3	1263	2	dullest
fillets	10	34	1475	2	fillets
fullers	10	38	1737	2	fullers
fullest	10	3	1334	2	fullest
gallets	8	35	1740	2	gallets
guglets	9	36	969	2	guglets
gullet	7	49	2483	2	gullet_
gulleys	11	43	852	2	gulleys
hullers	10	36	1626	2	hullers
lullers	7	32	1335	2	lullers
mallees	9	33	1597	2	mallees
mallet	8	44	3305	2	mallet_
malleus	9	29	1131	2	malleus
millers	9	36	2133	2	millers
milles	8	45	2656	2	mille_s
millet	8	40	3074	2	millet_
mulcts	10	29	871	2	mu_lcts
mules	7	50	3429	2	mu_le_s
muleta	8	3	923	2	mu_leta
muletas	9	3	738	2	mu_letas
muleys	11	40	964	2	mu_leys
mullahs	12	38	873	2	mullahs
mullas	8	42	1593	2	mull_as
mulled	9	47	2155	2	mulle_d
mullein	9	27	856	2	mullein
mulleins	10	27	705	2	mulleins
mullen	8	37	1476	2	mulle_n
muller	8	38	2035	2	mulle_r
mulley	11	40	1345	2	mulle_y
mullite	9	3	1301	2	mullite
mullites	10	4	1164	2	mullites
mulls	7	51	2415	2	mull__s
muskets	13	25	863	2	muskets
nutlets	7	41	1125	2	nutlets
outlets	7	36	1636	2	outlets
pallets	9	39	1930	2	pallets
pellets	9	40	1478	2	pellets
pullers	9	36	1848	2	pullers
pullet	8	40	2633	2	pullet_
pulleys	12	39	914	2	pulleys
quillets	17	25	682	2	quillets
rillets	7	42	1615	2	rillets
runlets	7	33	1077	2	runlets
sallets	7	37	1965	2	sallets
sublets	9	26	1670	2	sublets
tulles	6	32	1889	2	tulle_s
wallets	10	39	1483	2	wallets
willets	10	44	1432	2	willets

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	107671	0.140	1276364.3
2	DLD Change Limit	107671	72	4.250	25334.4
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	4.423	40400.4