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

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

94 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
teeming	10	35	1309	(None)
deeming	11	39	1312	1	deeming
seeming	10	32	1626	1	seeming
teaming	10	39	1759	1	teaming
teeing	7	39	1697	1	tee_ing
terming	10	40	1600	1	terming
theming	13	36	1047	1	theming
adeeming	12	5	479	2	adeeming
beaming	12	36	1880	2	beaming
beefing	13	39	1147	2	beefing
beeping	12	40	1391	2	beeping
berming	12	36	1483	2	berming
deeding	10	33	1512	2	deeding
esteeming	12	4	470	2	esteeming
feeding	12	35	1507	2	feeding
feeing	10	44	1650	2	fee_ing
feeling	11	36	1707	2	feeling
feezing	20	46	1016	2	feezing
geeing	8	43	1377	2	gee_ing
gemming	13	28	915	2	gemming
heeding	12	35	1506	2	heeding
heeling	11	36	1851	2	heeling
heezing	20	34	987	2	heezing
helming	13	37	1200	2	helming
hemming	15	26	997	2	hemming
iteming	10	3	775	2	iteming
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
lemming	12	26	939	2	lemming
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
perming	12	34	1609	2	perming
reaming	10	39	2401	2	reaming
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
seaming	10	32	2211	2	seaming
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
seemings	11	33	764	2	seemings
seeping	10	38	1791	2	seeping
steaming	11	40	1321	2	steaming
steeking	13	34	1135	2	steeking
steeling	9	36	1514	2	steeling
steeping	11	34	1258	2	steeping
steering	9	39	1679	2	steering
steeving	12	35	965	2	steeving
stemming	13	40	820	2	stemming
taming	9	40	2343	2	t_aming
tearing	8	40	2149	2	tearing
teasing	8	39	1851	2	teasing
tedding	10	32	1088	2	tedding
teemingly	15	4	507	2	teemingly
teething	12	3	716	2	teething
tegmina	10	3	524	2	tegmina
telexing	16	4	661	2	telexing
telling	8	33	2108	2	telling
temping	12	27	1069	2	temping
tending	9	44	1916	2	tending
tensing	8	46	1665	2	tensing
tenting	8	46	2115	2	tenting
termini	9	34	1081	2	termini
testing	8	60	2105	2	testing
tewing	10	39	1482	2	t_ewing
tieing	7	35	1876	2	tie_ing
tiering	8	3	1525	2	tiering
timing	9	36	1930	2	t_iming
toeing	7	44	1847	2	toe_ing
tomming	12	35	924	2	tomming
treeing	8	34	1430	2	treeing
tweeting	12	26	703	2	tweeting
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

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.406	440125.6
2	DLD Change Limit	107671	94	3.203	33615.7
3	Display Results	94	94	0.046	2043.5
	(SQL Overall)	178691	94	3.655	48889.5