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

Here are the results of your fuzzy-string dictionary search for “claypans” with Change Limit: [1] [2] [3] [4]

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.

75 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
claypans	15	4	387	(None)
claypan	14	3	431	1	claypan_
caymans	14	34	951	2	c_aymans
clachans	15	4	641	2	clachans
claybank	19	4	289	2	claybank
claybanks	20	4	241	2	claybanks
playpens	15	3	407	2	playpens
caftans	12	17	944	3	c_aftans
caimans	11	38	1178	3	c_aimans
callans	9	45	1847	3	c_allans
calpacs	13	31	1034	3	c_alpacs
calpains	12	3	976	3	c_alpains
calypsos	15	4	311	3	calypsos
cancans	11	3	1187	3	c_ancans
capons	10	41	1950	3	c_a_pons
captans	11	16	1205	3	c_aptans
carpals	11	34	1462	3	c_arpals
cayman	13	36	1321	3	c_ayman_
champacs	19	3	463	3	champacs
champaks	21	3	410	3	champaks
charpais	15	3	693	3	charpais
chazans	21	26	812	3	cha_zans
chazzans	21	23	450	3	chazzans
clachan	14	3	718	3	clachan_
claimant	12	4	748	3	claimant
claimants	13	4	428	3	claimants
clamant	11	3	1243	3	cla_mant
clampers	14	32	1189	3	clampers
clamping	15	40	1115	3	clamping
clamps	12	45	1508	3	clamp__s
clans	7	50	3101	3	cl___ans
clappers	14	33	1083	3	clappers
clapping	15	38	1060	3	clapping
claps	9	56	2618	3	cla_p__s
clarions	10	3	1049	3	clarions
claspers	12	44	1091	3	claspers
clasping	13	33	1026	3	clasping
clasps	10	45	1209	3	clasp__s
classons	10	3	770	3	classons
claxons	16	3	580	3	cla_xons
claying	13	36	1430	3	clay_ing
clays	10	55	2133	3	clay___s
clayware	16	4	393	3	clayware
claywares	17	4	346	3	claywares
cleans	8	58	1705	3	cl__eans
clypeus	14	3	324	3	cl_ypeus
crampons	14	3	664	3	crampons
crayons	12	43	923	3	cray_ons
cyans	10	57	1481	3	c__y_ans
deadpans	12	20	517	3	deadpans
frypans	15	4	405	3	_frypans
glycans	13	4	423	3	gl_ycans
japans	15	3	982	3	_ja_pans
lagans	7	57	1778	3	_la_gans
lallans	7	41	1353	3	_lallans
lampads	12	47	762	3	_lampads
lampas	10	66	1595	3	_lampa_s
lapins	8	45	2068	3	_la_pins
lauans	6	51	1353	3	_la_uans
layins	9	38	1765	3	_lay_ins
layman	11	35	1130	3	_layman_
platans	9	34	1312	3	pla_tans
playas	11	46	1228	3	play_a_s
playdays	17	4	297	3	playdays
playland	14	4	457	3	playland
playlands	15	4	389	3	playlands
playpen	14	3	469	3	playpen_
saltpans	10	3	481	3	saltpans
sampans	11	24	1100	3	_sampans
scalepans	13	4	382	3	scalepans
swanpans	13	4	342	3	swanpans
taipans	9	26	955	3	_taipans
tampans	11	33	1098	3	_tampans
tarpans	9	25	1353	3	_tarpans
trapans	9	28	1246	3	tra_pans

Search took 7 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	146162	0.173	1032896.0
2	DLD Change Limit	146162	75	6.390	22873.6
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	6.593	27103.1