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

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

42 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
comperes	14	32	1797	(None)
compares	14	38	1643	1	compares
compeers	14	34	1001	1	compeers
compere	13	46	1662	1	compere_
compered	15	34	1492	1	compered
competes	14	41	1724	1	competes
amperes	11	3	1398	2	_amperes
campers	13	42	2029	2	camper_s
chompers	17	36	959	2	chomper_s
coheres	12	29	1769	2	co_heres
combers	13	45	1662	2	comber_s
comers	10	53	2808	2	com_er_s
commerces	17	14	723	2	commerces
compadres	16	26	641	2	compadres
compare	13	58	1499	2	compare_
compared	15	38	1182	2	compared
comparer	14	36	1136	2	comparer
comparers	15	31	939	2	comparers
comparts	14	42	1083	2	comparts
compeer	13	38	1155	2	compe_er
compeered	16	4	630	2	compeered
compels	13	32	1089	2	compe_ls
compends	15	37	825	2	compends
compete	13	47	1655	2	compete_
competed	15	41	1359	2	competed
compiles	14	3	1198	2	compiles
completes	15	32	1292	2	completes
complexes	22	30	811	2	complexes
complies	14	3	1452	2	complies
comports	14	34	1198	2	comports
composes	14	50	1712	2	composes
compotes	14	47	1651	2	compotes
compress	14	3	905	2	compress
computes	14	39	1455	2	computes
coopered	13	33	1094	2	coopered
cooperies	13	11	1332	2	cooperies
coopers	11	40	1948	2	cooper_s
copers	10	46	2984	2	co_per_s
copperas	14	30	857	2	copperas
coppered	15	34	1054	2	coppered
coppers	13	35	1975	2	copper_s
rompers	11	34	1224	2	romper_s

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	42	4.033	30017.1
3	Display Results	42	42	0.013	3230.8
	(SQL Overall)	178691	42	4.436	40282.0