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

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

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.

73 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
coprisoners	15	5	311	(None)
coprisoner	14	5	356	1	coprisoner_
prisoners	11	4	737	2	__prisoners
copromoters	17	5	398	3	copromoters
coroners	10	40	1622	3	co_r__oners
cortisones	12	6	704	3	cortisone_s
poisoners	11	4	611	3	__poisoners
prisoner	10	4	857	3	__prisoner_
apprisers	13	4	505	4	appris__ers
boorishness	16	4	424	4	boorishness
caparisoned	16	9	175	4	caparisone_d
caparisons	14	4	367	4	caparison__s
caprioles	13	7	675	4	capri_ole_s
capsomers	15	4	475	4	cap__somers
cautioners	12	4	471	4	cauti_oners
cherishers	18	5	454	4	cheris_hers
choristers	15	8	609	4	choris_ters
clarionets	12	4	390	4	clari_onets
coarseness	12	4	617	4	coar_seness
codiscovers	19	5	212	4	co_discovers
codrivers	15	4	486	4	codri__vers
coiners	9	36	2075	4	co__i__ners
coltishness	16	4	504	4	coltishness
combiners	15	24	794	4	combi__ners
commissioners	19	7	251	4	commissioners
commoners	15	33	978	4	co__mmoners
comparisons	17	5	397	4	comparison__s
comprises	15	5	1094	4	compris__e_s
conciseness	15	4	666	4	conciseness
conditioners	15	6	392	4	conditioners
condoners	12	28	1150	4	co__ndoners
confiners	14	3	995	4	confi__ners
consigners	13	4	641	4	consi_gners
consolers	11	25	1092	4	co__nsolers
coparceners	17	5	234	4	coparceners
copartners	14	4	357	4	cop_artners
copestones	14	6	761	4	copestone_s
copiers	11	42	1596	4	cop_i___ers
copresents	14	4	645	4	copresen_ts
coprinces	15	4	748	4	copri__nces
coproducers	18	6	253	4	coproducers
copromoter	16	4	457	4	copromoter_
corianders	13	4	489	4	co_rianders
corners	9	47	2331	4	co_r___ners
cornpones	13	4	710	4	co_rnpone_s
coronels	10	40	1214	4	co_r__onels
coroner	9	42	1820	4	co_r__oner_
coronets	10	38	1436	4	co_r__onets
corridors	12	4	506	4	corrido__rs
cortisone	11	4	704	4	cortisone__
cosigners	12	4	513	4	co_si_gners
couriers	10	32	1316	4	couri___ers
coursers	10	44	1229	4	cour_s__ers
cowinners	14	4	413	4	co_wi_nners
cowriters	14	31	727	4	cowri__ters
crayoners	14	4	448	4	c__rayoners
crispers	12	30	943	4	c__ris_pers
crispness	13	4	530	4	c__rispness
crooners	10	39	1139	4	c__r_ooners
foppishness	21	5	349	4	foppishness
imprisoned	15	5	294	4	imprisone_d
imprisons	13	4	491	4	imprison__s
loriners	8	3	996	4	lo_ri__ners
motioners	11	4	657	4	mo_ti_oners
nonrioters	10	4	551	4	nonri_oters
nourishers	13	8	363	4	nouris_hers
optionees	11	4	434	4	_opti_onees
orisons	7	3	1056	4	_o_rison__s
poisoner	10	4	698	4	__poisoner_
portioners	12	5	741	4	po_rtioners
prisoned	11	3	881	4	__prisone_d
prisons	9	3	1322	4	__prison__s
uprisers	10	20	677	4	_upris__ers

Search took 10 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	148819	0.173	1032896.0
2	DLD Change Limit	148819	73	8.860	16796.7
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	9.063	19716.5