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

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

125 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
chapiters	16	3	520	(None)
chapiter	15	3	660	1	chapiter_
chapters	15	40	1213	1	chap_ters
chanters	13	40	1674	2	cha_nters
chapter	14	42	1385	2	chap_ter_
charters	13	41	1558	2	cha_rters
chatters	13	42	1395	2	cha_tters
chaunters	14	5	582	2	chaunters
cohabiters	17	4	340	2	cohabiters
accipiters	16	16	281	3	accipiters
adapters	11	3	610	3	adap_ters
awaiters	11	4	664	3	awa_iters
baiters	9	46	1930	3	_ba_iters
cahiers	12	35	1067	3	c_ahi_ers
calibers	12	3	852	3	c_alibers
calipers	12	4	944	3	c_alipers
canisters	11	23	1019	3	c_anisters
canters	9	48	2773	3	c_a_nters
caperers	12	26	1172	3	c_aperers
capers	10	54	2814	3	c_ap__ers
capitals	12	20	945	3	c_apitals
capitols	12	24	733	3	c_apitols
capizes	20	4	1037	3	c_apize_s
capotes	11	3	1464	3	c_apote_s
cappers	13	44	1940	3	c_ap_pers
captors	11	39	1498	3	c_ap_tors
carters	9	53	2725	3	c_a_rters
casters	9	47	2990	3	c_a_sters
caters	8	53	3650	3	c_a__ters
cavilers	13	4	811	3	c_avilers
chafers	15	45	1274	3	cha__fers
chaffers	19	37	800	3	cha_ffers
chaines	12	45	1873	3	cha_ine_s
chairs	11	49	1618	3	cha_i__rs
chaises	12	43	1749	3	cha_ise_s
chalices	15	3	1081	3	chalice_s
chambers	17	34	1062	3	cha_mbers
chamfers	18	40	922	3	cha_mfers
chamises	15	35	1331	3	chamise_s
champers	17	33	1162	3	cha_mpers
chancers	15	43	1349	3	cha_ncers
chandlers	15	38	767	3	chandlers
changers	14	43	1320	3	cha_ngers
chanter	12	39	1973	3	cha_nter_
chanteys	16	38	749	3	cha_nteys
chanties	13	26	1580	3	chantie_s
chantors	13	37	1026	3	cha_ntors
chapatis	15	12	794	3	chapat_is
chapattis	16	8	361	3	chapattis
chapels	14	42	915	3	chap__els
chapes	13	54	2187	3	chap__e_s
chaplets	15	5	688	3	chap_lets
chappies	17	26	1010	3	chappie_s
chapteral	16	4	470	3	chap_teral
chaptered	17	17	679	3	chap_tered
characters	17	4	550	3	characters
chargers	14	40	1132	3	cha_rgers
charier	12	43	1790	3	chari_er_
chariness	14	3	1006	3	chariness
charioteers	16	5	243	3	charioteers
charities	14	3	1274	3	charities
charmers	15	42	1133	3	cha_rmers
charter	12	39	1830	3	cha_rter_
chasers	12	37	1492	3	cha__sers
chastens	13	42	918	3	cha_stens
chaster	12	47	1850	3	cha_ster_
chastisers	15	4	317	3	chastisers
chattels	13	28	679	3	cha_ttels
chatter	12	44	1664	3	cha_tter_
chattery	16	35	727	3	cha_ttery
chattier	13	3	751	3	chattier_
chaufers	16	34	730	3	cha_ufers
chauffers	20	25	344	3	chauffers
chaunter	13	6	639	3	chaunter_
chawers	15	44	1205	3	cha__wers
chayotes	16	3	650	3	chayote_s
cheapeners	17	4	311	3	cheapeners
cheapies	15	3	903	3	cheapi_e_s
cheaters	13	36	1351	3	ch_eaters
chedites	14	3	826	3	chedite_s
chiders	13	53	1294	3	ch__iders
chimers	14	45	1514	3	ch__imers
chippers	17	35	1088	3	chip_pers
chitters	13	37	1117	3	ch_itters
chopines	15	27	1173	3	chopine_s
choppers	17	41	1046	3	chop_pers
choristers	15	8	610	3	choristers
chunters	13	39	1090	3	ch_unters
citers	8	50	2298	3	c___iters
claimers	12	29	874	3	cla_imers
clappers	14	33	1083	3	clap_pers
clatters	10	33	1391	3	cla_tters
claviers	13	6	710	3	clavi_ers
coasters	10	43	1733	3	coa_sters
coaters	9	35	2579	3	coa__ters
cohabiter	16	4	396	3	cohabiter_
compilers	15	3	705	3	compilers
computers	15	33	975	3	computers
copiers	11	42	1596	3	c_opi_ers
copters	11	36	2128	3	c_op_ters
cowriters	14	31	728	3	cowriters
crafters	13	41	995	3	cra_fters
crappers	14	40	1102	3	crap_pers
craters	9	50	2189	3	cra__ters
cyanites	13	26	1016	3	cyanite_s
gaiters	8	35	1654	3	_ga_iters
hafters	13	46	1433	3	_ha_fters
hailers	10	40	1726	3	_ha_ilers
halites	10	32	2119	3	_halite_s
halters	10	46	1980	3	_ha_lters
hamsters	13	7	1042	3	_hamsters
haplites	13	3	999	3	_haplite_s
haptens	12	45	1134	3	_hap_tens
haters	9	49	3040	3	_ha__ters
hatters	10	42	2152	3	_ha_tters
haunters	11	32	954	3	_haunters
hipsters	13	26	879	3	_hipsters
inhabiters	15	4	340	3	inhabiters
plaiters	10	35	1263	3	pla_iters
rapiers	9	50	1287	3	_rapi_ers
shapers	12	40	1689	3	shap__ers
shatters	11	33	1391	3	sha_tters
tapsters	10	31	880	3	_tapsters
waiters	10	42	1862	3	_wa_iters
whappers	18	27	674	3	whap_pers

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	125	7.373	20160.2
3	Display Results	125	125	0.046	2717.4
	(SQL Overall)	178691	125	7.842	22786.4