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

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

105 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
comethers	16	3	743	(None)
comether	15	3	725	1	comether_
comembers	17	4	422	2	comembers
coveters	13	24	1107	2	covet_ers
aethers	10	36	1494	3	__aethers
ammeters	12	3	769	3	ammet_ers
biometers	13	3	915	3	biomet_ers
blethers	13	42	961	3	_blethers
bothers	12	43	1775	3	bo__thers
cameleers	13	4	509	3	cameleers
cementers	13	3	830	3	cementers
cemetery	15	5	492	3	cemet_ery
cithers	12	43	1575	3	c__ithers
coachers	15	43	1229	3	co_achers
coasters	10	43	1730	3	coast_ers
coaters	9	35	2577	3	co_at_ers
coauthors	14	4	429	3	coauthors
coercers	12	3	765	3	co_ercers
coherers	13	23	1073	3	cohe_rers
cointers	10	36	1640	3	coint_ers
coleaders	12	3	780	3	coleaders
colters	9	35	2243	3	co_lt_ers
comakers	16	33	916	3	com_akers
comates	11	41	2363	3	comat_e_s
combaters	15	3	809	3	combaters
combers	13	45	1661	3	com__bers
combiners	15	24	794	3	combiners
comedies	13	3	1183	3	comedie_s
comelier	12	3	1065	3	comelier_
comember	16	4	416	3	comember_
comers	10	53	2808	3	com___ers
cometary	15	4	769	3	comet_ary
cometh	13	48	1168	3	cometh___
comets	10	58	2358	3	comet___s
comities	12	3	1778	3	comitie_s
commencers	18	15	637	3	commencers
commenders	17	13	714	3	commenders
commenters	16	13	947	3	commenters
commoners	15	33	978	3	commoners
communers	15	33	840	3	communers
commuters	15	37	888	3	commuters
comparers	15	31	938	3	comparers
compeers	14	34	1001	3	com_peers
compellers	16	4	519	3	compellers
competes	14	41	1724	3	compet_e_s
compilers	15	3	705	3	compilers
completers	16	29	832	3	complet_ers
compliers	15	3	829	3	compliers
composers	15	39	1061	3	composers
computers	15	33	973	3	computers
comtes	10	62	2281	3	com_t_e_s
cooters	9	45	2571	3	co_ot_ers
copters	11	36	2127	3	co_pt_ers
coshers	12	36	1817	3	co__shers
costers	9	41	2830	3	co_st_ers
cotters	9	43	2343	3	co__tters
cottiers	10	39	915	3	co_ttiers
couchers	15	35	1384	3	co_uchers
coughers	14	39	995	3	co_ughers
coulters	10	36	1430	3	coult_ers
counters	10	33	2018	3	count_ers
courters	10	30	1536	3	court_ers
courtiers	11	4	668	3	courtiers
couters	9	38	2728	3	co_ut_ers
couther	12	39	1462	3	co_uther_
coverers	13	27	1212	3	cove_rers
coveter	12	29	1206	3	covet_er_
cozeners	19	29	778	3	coze_ners
cryometers	17	4	599	3	cryomet_ers
diethers	12	5	745	3	_diethers
dimeters	11	4	1108	3	dimet_ers
ethers	9	45	1841	3	___ethers
fomenters	14	3	785	3	fomenters
geometers	12	3	818	3	geomet_ers
godmothers	17	5	263	3	godmothers
homeotherm	20	5	360	3	homeotherm
homeotherms	21	5	304	3	homeotherms
loathers	11	33	1043	3	lo_athers
meters	8	56	2583	3	__met_ers
metiers	9	33	1284	3	__metiers
mithers	12	35	1673	3	__mithers
mothers	12	37	1762	3	__mothers
mouthers	13	38	1130	3	mo_uthers
northers	11	3	933	3	no_rthers
odometers	12	4	713	3	odomet_ers
omitters	10	27	765	3	_omitters
orometers	11	3	1040	3	oromet_ers
others	9	39	1800	3	_o__thers
picometers	16	4	827	3	picomet_ers
pothers	12	38	1862	3	po__thers
scouthers	14	4	599	3	sco_uthers
smithers	13	36	979	3	_smithers
smoothers	14	20	604	3	smoothers
smothers	13	34	993	3	_smothers
somewhere	17	4	247	3	somewhere
somewheres	18	5	233	3	somewheres
soothers	11	39	1343	3	so_others
southers	11	42	1445	3	so_uthers
teethers	11	32	871	3	_teethers
tethers	10	38	1531	3	__tethers
together	12	4	374	3	together_
udometers	12	4	574	3	udomet_ers
untethers	12	4	415	3	untethers
vomiters	13	3	720	3	vomit_ers
wethers	13	52	1469	3	__wethers

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	148641	0.173	1032896.0
2	DLD Change Limit	148641	105	8.890	16720.0
3	Display Results	105	105	0.046	2282.6
	(SQL Overall)	178691	105	9.109	19617.0