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

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

72 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
compadre	15	29	588	(None)
compadres	16	26	641	1	compadres
compare	13	58	1499	1	compa_re
comade	11	44	1532	2	com_ad_e
compared	15	38	1182	2	compa_red
comparer	14	36	1136	2	compa_rer
compares	14	38	1643	2	compa_res
compart	13	40	1600	2	compa_rt
compere	13	46	1662	2	comp_ere
compradore	17	5	274	2	compradore
comrade	12	13	921	2	comrad_e
cadre	8	54	1902	3	c___adre
campagne	15	4	441	3	campagne
campfire	17	4	402	3	campfire
camphire	17	4	589	3	camphire
cockade	16	3	813	3	cockad_e
coleader	11	3	918	3	coleader
comae	9	71	2842	3	com_a__e
comake	14	44	1342	3	com_a_ke
comaker	15	34	1060	3	com_aker
comate	10	41	2484	3	com_a_te
combater	14	3	938	3	combater
commander	16	12	740	3	commander
commode	14	3	812	3	commod_e
commodore	16	4	420	3	commodore
compact	15	37	1221	3	compa_ct
compacted	18	29	736	3	compacted
compacter	17	25	788	3	compacter
compacts	16	36	890	3	compacts
companied	16	4	802	3	companied
companies	15	3	1180	3	companies
company	16	197	1114	3	compa_ny
comparers	15	31	939	3	comparers
comparted	16	33	842	3	comparted
comparts	14	42	1083	3	comparts
compas	12	58	1706	3	compa__s
compass	13	37	956	3	compa_ss
compassed	16	4	554	3	compassed
compasses	15	4	739	3	compasses
comped	13	59	1987	3	comped__
compeer	13	38	1155	3	compeer_
compeered	16	4	630	3	compeered
compeers	14	34	1001	3	compeers
compered	15	34	1492	3	comp_ered
comperes	14	32	1797	3	comp_eres
compete	13	47	1655	3	comp_ete
compile	13	3	1244	3	comp_ile
compiler	14	3	837	3	compiler
complete	14	34	1205	3	complete
complice	16	3	933	3	complice
complier	14	3	1025	3	complier
compline	14	3	1355	3	compline
compone	13	65	1719	3	comp_one
comport	13	36	1684	3	comp_ort
compose	13	57	1666	3	comp_ose
composer	14	50	1295	3	composer
composure	15	4	512	3	composure
compote	13	56	1646	3	comp_ote
comprador	16	4	359	3	comprador
compradores	18	5	260	3	compradores
compradors	17	4	378	3	compradors
comprise	14	3	1081	3	comprise
comprize	23	6	873	3	comprize
compute	13	45	1366	3	comp_ute
computer	14	45	1151	3	computer
comradery	17	9	349	3	comradery
comrades	13	14	977	3	comrades
corrade	10	11	1104	3	corrad_e
couvade	13	3	506	3	couvad_e
madre	8	57	2017	3	__m_adre
padre	8	60	1816	3	___padre
pomade	11	36	1133	3	pom_ad_e

Search took 8 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.436	409841.7
2	DLD Change Limit	146162	72	7.313	19986.6
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	7.779	22970.9