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

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

54 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
plaices	11	4	1114	(None)
places	10	43	2370	1	pla_ces
plaice	10	3	1155	1	plaice_
calices	11	43	2169	2	calices
glaces	9	42	1802	2	gla_ces
glaires	8	40	1013	2	glaires
glaives	11	34	783	2	glaives
glances	10	41	1314	2	glances
laces	7	61	4176	2	_la_ces
laichs	11	51	1089	2	_laichs
laics	7	64	1925	2	_laic_s
lances	8	48	2410	2	_lances
latices	9	3	1376	2	_latices
malices	11	43	1662	2	malices
paces	9	67	4111	2	p_a_ces
palaces	11	42	1645	2	palaces
peaces	10	63	2408	2	pea_ces
place	9	48	2461	2	pla_ce_
placed	11	43	1800	2	pla_ced
placer	10	51	1774	2	pla_cer
placers	11	45	1526	2	pla_cers
placet	10	39	2367	2	pla_cet
placets	11	39	1122	2	pla_cets
placks	14	44	1415	2	pla_cks
plages	9	45	2015	2	pla_ges
plagues	10	33	1106	2	plagues
plaided	11	40	964	2	plaided
plaids	9	43	1244	2	plai_ds
plained	10	38	1223	2	plained
plainer	9	38	1198	2	plainer
plainest	10	3	1361	2	plainest
plains	8	50	1959	2	plai_ns
plaints	9	40	1205	2	plaints
plaited	10	37	1389	2	plaited
plaiter	9	36	1539	2	plaiter
plaiters	10	35	1263	2	plaiters
plaits	8	38	1647	2	plai_ts
planches	15	31	1186	2	planches
planes	8	50	2808	2	pla_nes
plaques	18	31	789	2	plaques
plashes	12	44	1739	2	plashes
plates	8	54	3224	2	pla_tes
platies	9	37	2254	2	platies
plies	7	45	2651	2	pl_i_es
polices	11	31	1805	2	polices
pollices	12	4	1075	2	pollices
praises	9	41	2110	2	praises
prances	11	36	1877	2	prances
prices	10	45	2454	2	p_rices
pumices	13	3	827	2	pumices
saices	8	42	2180	2	_saices
slices	8	40	2285	2	sl_ices
sluices	9	5	907	2	sluices
splices	11	39	1438	2	spl_ices

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.436	409841.7
2	DLD Change Limit	107671	54	3.046	35348.3
3	Display Results	54	54	0.016	3375.0
	(SQL Overall)	178691	54	3.498	51083.8