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

Here are the results of your fuzzy-string dictionary search for “comparers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

119 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
comparers	15	31	939	(None)
comparer	14	36	1136	1	comparer_
compares	14	38	1643	1	compare_s
comakers	16	33	917	2	com_akers
combaters	15	3	811	2	combaters
compacters	18	24	702	2	compacters
compadres	16	26	641	2	compadre_s
compare	13	58	1499	2	compare__
compared	15	38	1182	2	compare_d
comparts	14	42	1083	2	compar_ts
compeers	14	34	1001	2	comp_eers
comperes	14	32	1797	2	compere_s
compilers	15	3	705	2	compilers
compliers	15	3	829	2	compliers
composers	15	39	1062	2	composers
compress	14	3	905	2	comp_ress
computers	15	33	975	2	computers
bombarders	17	15	320	3	bombarders
campers	13	42	2029	3	camp__ers
camporees	15	4	610	3	camporees
caperers	12	26	1172	3	c_aperers
capmakers	19	4	472	3	capmakers
carers	8	51	3396	3	c___arers
cellarers	11	23	650	3	cellarers
chompers	17	36	959	3	chomp__ers
clearers	10	34	930	3	c_learers
coalers	9	44	1935	3	co__alers
coaters	9	35	2579	3	co__aters
coaxers	16	43	1108	3	co__axers
coherers	13	23	1073	3	co_herers
coleaders	12	3	782	3	coleaders
collarets	11	32	733	3	collarets
colorers	10	3	1218	3	co_lorers
colourers	11	3	647	3	colourers
comaker	15	34	1060	3	com_aker_
comakes	15	44	1364	3	com_ake_s
comanagers	15	4	383	3	comanagers
comates	11	41	2364	3	com_ate_s
combater	14	3	938	3	combater_
combers	13	45	1662	3	com__bers
combiners	15	24	794	3	combiners
comembers	17	4	422	3	comembers
comers	10	53	2808	3	com___ers
comethers	16	3	744	3	comethers
comforters	17	27	519	3	comforters
comfreys	18	4	333	3	com_freys
commanders	17	14	668	3	commanders
commoners	15	33	978	3	commoners
communers	15	33	841	3	communers
commuters	15	37	891	3	commuters
compacter	17	25	788	3	compacter_
compactors	18	25	625	3	compactors
compacts	16	36	890	3	compa_cts
compadre	15	29	588	3	compa_dre
companies	15	3	1180	3	companies
comparators	17	8	568	3	comparators
comparing	16	24	1058	3	comparing
compart	13	40	1600	3	compa__rt
comparted	16	33	842	3	comparted
compas	12	58	1706	3	compa___s
compass	13	37	956	3	compa__ss
compasses	15	4	739	3	compasses
compeer	13	38	1155	3	comp_eer_
compellers	16	4	519	3	compellers
compels	13	32	1088	3	comp__els
compere	13	46	1662	3	comp__ere
compered	15	34	1492	3	compere_d
competes	14	41	1724	3	compete_s
compiler	14	3	837	3	compiler_
compiles	14	3	1198	3	compile_s
complainers	17	4	447	3	complainers
completers	16	29	832	3	completers
complier	14	3	1025	3	complier_
complies	14	3	1452	3	complie_s
comports	14	34	1198	3	compor_ts
composer	14	50	1295	3	composer_
composes	14	50	1711	3	compose_s
composters	16	38	832	3	composters
compotes	14	47	1651	3	compote_s
compradors	17	4	378	3	compradors
computer	14	45	1151	3	computer_
computes	14	39	1455	3	compute_s
comradery	17	9	349	3	comradery
comrades	13	14	977	3	comrade_s
conjurers	18	12	623	3	conjurers
conspirers	14	4	457	3	conspirers
coopers	11	40	1948	3	coop__ers
coparent	12	4	1225	3	co_parent
coparents	13	4	797	3	co_parents
copartners	14	4	357	3	co_partners
copers	10	46	2984	3	co_p__ers
copiers	11	42	1596	3	co_p_iers
coppers	13	35	1975	3	co_p_pers
copters	11	36	2128	3	co_p_ters
corers	8	52	3107	3	co___rers
cottagers	12	30	538	3	cottagers
couplers	12	33	1132	3	coup_lers
coverers	13	27	1212	3	co_verers
cumberers	15	17	600	3	cumberers
cymbalers	18	4	284	3	cymbalers
empalers	12	22	674	3	_empalers
hamperers	16	28	753	3	hamperers
homagers	14	8	682	3	hom_agers
impairers	13	4	371	3	_impairers
impalers	12	22	697	3	_impalers
imparters	13	27	657	3	_imparters
pamperers	15	23	686	3	pamperers
parers	8	55	3074	3	___parers
preparers	13	19	767	3	preparers
rampagers	14	4	386	3	rampagers
roarers	7	38	1274	3	ro__arers
rompers	11	34	1224	3	romp__ers
scamperers	16	4	347	3	scamperers
simperers	13	3	593	3	simperers
smearers	10	30	862	3	_smearers
soarers	7	41	1809	3	so__arers
sparers	9	45	1961	3	__sparers
tamperers	13	22	731	3	tamperers
temperers	13	24	702	3	temperers

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	148641	0.423	422437.4
2	DLD Change Limit	148641	119	7.000	21234.4
3	Display Results	119	119	0.063	1888.9
	(SQL Overall)	178691	119	7.486	23870.0