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

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

79 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
plaids	9	43	1244	(None)
plaid	8	51	1830	1	plaid_
plains	8	50	1959	1	plains
plaits	8	38	1647	1	plaits
aids	5	78	4636	2	__aids
alands	7	54	1837	2	alands
alcids	9	48	1229	2	alcids
blains	8	45	1637	2	blains
braids	9	50	1569	2	braids
caids	8	52	2642	2	_caids
clads	8	57	2273	2	cla_ds
claims	10	52	1157	2	claims
elains	6	49	1985	2	elains
elands	7	49	1477	2	elands
elapids	10	3	650	2	elapids
flails	9	43	1300	2	flails
flairs	9	57	1191	2	flairs
fluids	10	34	942	2	fluids
glads	7	56	2061	2	gla_ds
glairs	7	52	1133	2	glairs
glands	8	53	1440	2	glands
halids	10	40	1613	2	halids
iliads	7	44	867	2	iliads
lads	5	65	4913	2	_la_ds
laics	7	64	1925	2	_laics
laid	5	64	3914	2	_laid_
lairds	7	47	1161	2	_lairds
lairs	5	54	2587	2	_lairs
lands	6	54	2690	2	_lands
lards	6	53	3186	2	_lards
lauds	6	56	1848	2	_lauds
lids	5	63	3646	2	_l_ids
loids	6	62	2070	2	_loids
maids	8	63	2714	2	_maids
padis	8	62	2714	2	p_adis
pads	7	67	4295	2	p_a_ds
paid	7	57	3748	2	p_aid_
paiks	11	47	1985	2	p_aiks
pails	7	58	3306	2	p_ails
pains	7	51	3828	2	p_ains
pairs	7	53	2583	2	p_airs
palais	8	4	2042	2	palai_s
pards	8	56	3433	2	p_ards
places	10	43	2370	2	places
placid	11	40	1254	2	placid_
placks	14	44	1415	2	placks
placoids	13	4	734	2	placoids
plages	9	45	2015	2	plages
plaice	10	3	1155	2	plaice
plaices	11	4	1114	2	plaices
plaided	11	40	964	2	plaided
plain	7	48	2330	2	plai_n
plaint	8	53	2320	2	plaint
plaints	9	40	1205	2	plaints
plait	7	56	3157	2	plai_t
planes	8	50	2808	2	planes
planks	12	41	1675	2	planks
plans	7	57	3127	2	pla_ns
plants	8	49	2180	2	plants
plasmids	13	23	655	2	plasmids
plasms	10	37	1133	2	plasms
plastids	11	26	921	2	plastids
plates	8	54	3224	2	plates
platies	9	37	2254	2	platies
plats	7	55	3137	2	pla_ts
platys	11	45	985	2	platys
playas	11	46	1228	2	playas
plays	10	63	2077	2	pla_ys
plazas	17	40	991	2	plazas
pleads	9	46	1395	2	pleads
pleiads	10	4	522	2	pleiads
plies	7	45	2651	2	pl_ies
plods	8	57	1929	2	pl_ods
ploidy	12	3	748	2	ploidy
qaids	15	61	1631	2	_qaids
raids	6	58	2751	2	_raids
saids	6	53	2885	2	_saids
sloids	7	37	1269	2	sloids
uplands	10	3	694	2	uplands

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	79	2.533	32590.2
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	2.906	61490.4