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

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

86 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
compeered	16	4	630	(None)
compered	15	34	1492	1	comp_ered
compared	15	38	1182	2	comp_ared
compeer	13	38	1155	2	compeer__
compeers	14	34	1001	2	compeer_s
compelled	16	4	613	2	compelled
compere	13	46	1662	2	comp_ere_
comperes	14	32	1797	2	comp_eres
competed	15	41	1359	2	comp_eted
completed	16	28	1027	2	completed
complexed	23	29	598	2	complexed
coopered	13	33	1094	2	coop_ered
coppered	15	34	1054	2	co_ppered
bumpered	15	3	600	3	bump_ered
cambered	15	12	900	3	cam_bered
capered	12	30	1404	3	c_ap_ered
careered	11	3	950	3	c_areered
chaptered	17	17	680	3	chaptered
cheered	13	37	1330	3	c__heered
chippered	19	4	500	3	chippered
choppered	19	6	488	3	choppered
ciphered	16	3	705	3	c_iphered
coappeared	17	4	227	3	coappeared
cockered	17	7	1021	3	co_ckered
coffered	17	3	767	3	co_ffered
cohered	13	35	1469	3	co__hered
coinhered	15	3	659	3	coinhered
commenced	18	15	713	3	commenced
commended	17	13	701	3	commended
commented	16	12	961	3	commented
commerced	18	12	546	3	commerced
compacted	18	29	736	3	compacted
compadre	15	29	588	3	compadre_
compadres	16	26	641	3	compadres
companied	16	4	802	3	companied
compare	13	58	1499	3	comp_are_
comparer	14	36	1136	3	comp_arer
compares	14	38	1643	3	comp_ares
comparted	16	33	842	3	comparted
compassed	16	4	554	3	compassed
comped	13	59	1987	3	comp___ed
compeering	17	4	705	3	compeering
compeller	15	4	629	3	compeller
compend	14	40	1030	3	comp_e_nd
compete	13	47	1655	3	comp_ete_
competes	14	41	1724	3	comp_etes
compiled	15	3	781	3	comp_iled
complected	19	29	586	3	complected
complete	14	34	1205	3	complete_
completer	15	33	1041	3	completer
completes	15	32	1292	3	completes
complexer	22	31	621	3	complexer
complexes	22	30	811	3	complexes
complied	15	3	968	3	comp_lied
comported	16	31	953	3	comported
composed	15	46	1206	3	comp_osed
composted	16	37	882	3	composted
comprehend	20	7	394	3	comprehend
compressed	17	4	584	3	compressed
comprised	16	4	805	3	comprised
comprized	25	6	722	3	comprized
compted	14	38	1352	3	comp__ted
computed	15	41	1095	3	comp_uted
conferred	15	3	775	3	conferred
conquered	21	4	546	3	conquered
cornered	11	3	1113	3	co_rnered
coshered	14	6	1029	3	co_shered
cottered	11	25	1174	3	co_ttered
countered	12	3	1300	3	countered
covered	13	33	1529	3	co__vered
cowered	13	32	1465	3	co__wered
cumbered	15	15	796	3	cum_bered
cyphered	19	3	465	3	c_yphered
domineered	14	4	252	3	domineered
hampered	16	23	993	3	hamp_ered
homebred	16	21	589	3	hom_ebred
homered	13	32	1271	3	hom__ered
loppered	13	32	675	3	lo_ppered
pampered	15	22	923	3	pamp_ered
peered	9	38	1949	3	___peered
scampered	16	3	523	3	scamp_ered
schmeered	17	4	327	3	schm_eered
simpered	13	3	825	3	simp_ered
speered	10	36	1481	3	__speered
tampered	13	27	946	3	tamp_ered
tempered	13	24	822	3	temp_ered

Search took 9 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	148641	0.423	422437.4
2	DLD Change Limit	148641	86	7.563	19653.7
3	Display Results	86	86	0.046	1869.6
	(SQL Overall)	178691	86	8.032	22247.4