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

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

88 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
heezing	20	34	987	(None)
feezing	20	46	1016	1	feezing
heeding	12	35	1506	1	heeding
heeling	11	36	1851	1	heeling
wheezing	24	31	538	1	wheezing
beefing	13	39	1147	2	beefing
beeping	12	40	1391	2	beeping
breezing	20	36	813	2	breezing
cheeking	18	34	908	2	cheeking
cheeping	16	32	955	2	cheeping
cheering	14	36	1270	2	cheering
cheesing	14	34	941	2	cheesing
deeding	10	33	1512	2	deeding
deeming	11	39	1312	2	deeming
feazing	20	54	1144	2	feazing
feeding	12	35	1507	2	feeding
feeing	10	44	1650	2	fee_ing
feeling	11	36	1707	2	feeling
freezing	21	30	832	2	freezing
geeing	8	43	1377	2	gee_ing
haeing	10	41	1892	2	hae_ing
hazing	19	42	1855	2	h_azing
heading	12	29	1911	2	heading
healing	11	39	2296	2	healing
heaping	13	30	1585	2	heaping
hearing	11	33	2416	2	hearing
heating	11	40	2432	2	heating
heaving	14	41	1476	2	heaving
hedging	13	34	895	2	hedging
heelings	12	35	975	2	heelings
hefting	14	45	1091	2	hefting
heiling	11	36	1636	2	heiling
heiring	11	33	1290	2	heiring
helling	11	46	2322	2	helling
helming	13	37	1200	2	helming
helping	13	35	1222	2	helping
helving	14	40	1113	2	helving
hemming	15	26	997	2	hemming
henting	11	37	1965	2	henting
herding	12	29	1512	2	herding
herring	11	36	1588	2	herring
hewing	13	45	1424	2	h_ewing
hexing	17	42	1051	2	h_exing
hieing	10	42	1662	2	hie_ing
hoeing	10	41	1702	2	hoe_ing
jeeing	14	45	1214	2	jee_ing
jeeping	17	40	1033	2	jeeping
jeering	15	35	1304	2	jeering
keeking	11	42	1089	2	keeking
keeling	12	35	1512	2	keeling
keening	12	37	1315	2	keening
keeping	14	40	1254	2	keeping
leering	8	34	1764	2	leering
meeting	10	33	1496	2	meeting
needing	9	32	1442	2	needing
peeing	9	46	1808	2	pee_ing
peeking	14	44	1495	2	peeking
peeling	10	29	1987	2	peeling
peening	10	33	1830	2	peening
peeping	12	36	1521	2	peeping
peering	10	35	2035	2	peering
peeving	13	51	1224	2	peeving
reeding	9	41	2413	2	reeding
reefing	11	40	1686	2	reefing
reeking	12	33	1864	2	reeking
reeling	8	31	2686	2	reeling
reeving	11	37	1766	2	reeving
seeding	9	37	1948	2	seeding
seeing	7	42	2214	2	see_ing
seeking	12	40	1606	2	seeking
seeling	8	35	2200	2	seeling
seeming	10	32	1626	2	seeming
seeping	10	38	1791	2	seeping
seizing	17	41	1483	2	seizing
sheening	12	30	1080	2	sheening
sheering	12	37	1510	2	sheering
sheeting	12	27	1283	2	sheeting
sneezing	18	26	705	2	sneezing
teeing	7	39	1697	2	tee_ing
teeming	10	35	1309	2	teeming
tweezing	21	38	411	2	tweezing
veering	11	32	1368	2	veering
weeding	12	38	1521	2	weeding
weening	11	41	1397	2	weening
weeping	13	36	1367	2	weeping
weeting	11	38	1605	2	weeting
wheeling	15	31	860	2	wheeling
wheeping	17	33	710	2	wheeping

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	107671	0.373	479064.3
2	DLD Change Limit	107671	88	2.893	37217.8
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	3.296	54214.5