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

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

98 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
whereto	13	4	606	(None)
hereto	9	3	1369	1	_hereto
thereto	10	3	899	1	thereto
where	11	70	1942	2	where__
whereas	13	44	890	2	whereas
whereat	13	43	1192	2	whereat
whereby	18	4	291	2	whereby
wherein	13	21	659	2	wherein
whereinto	15	5	234	2	whereinto
whereof	16	18	546	2	whereof
whereon	13	19	650	2	whereon
wheres	12	59	1743	2	where_s
whereunto	15	5	178	2	whereunto
beret	7	49	4636	3	_beret_
berets	8	58	2252	3	_berets
cheerio	12	37	931	3	cheerio
cheero	11	47	1293	3	che_ero
cheroot	12	4	1369	3	cheroot
chert	10	52	3210	3	cher_t_
cherts	11	56	1723	3	cher_ts
cherty	14	46	1247	3	cher_ty
chevret	15	33	1063	3	chevret_
chevrets	16	25	532	3	chevrets
gherao	10	3	675	3	gher_ao
ghetto	10	3	607	3	ghe_tto
here	7	64	4710	3	_here__
hereat	9	35	2741	3	_hereat
hereby	14	46	833	3	_hereby
herein	9	37	1779	3	_herein
hereinto	11	4	543	3	_hereinto
hereof	12	32	1237	3	_hereof
hereon	9	39	1436	3	_hereon
heres	8	62	4590	3	_here_s
heresy	12	50	1123	3	_heresy
heretic	12	3	1483	3	_heretic
hereunto	11	4	371	3	_hereunto
heriot	9	4	2234	3	_heriot
heritor	10	3	1056	3	_heritor
hero	7	46	3578	3	_her__o
hertz	17	49	1903	3	_her_tz
hetero	9	3	1263	3	_hetero
phenetol	13	4	406	3	phenetol
sheet	8	48	3695	3	she_et_
sheets	9	39	1849	3	she_ets
shegetz	20	4	426	3	shegetz
sherbet	12	3	1138	3	sherbet_
sherbets	13	3	521	3	sherbets
shereef	13	3	774	3	shereef
sheroot	10	4	1437	3	sheroot
stereo	6	53	1791	3	stere_o
teredo	7	3	1078	3	_teredo
terete	6	3	1933	3	_terete
there	8	75	2739	3	there__
thereat	10	43	1524	3	thereat
thereby	15	3	463	3	thereby
therefor	14	9	445	3	therefor
therein	10	23	1035	3	therein
thereinto	12	4	392	3	thereinto
thereof	13	16	806	3	thereof
thereon	10	19	926	3	thereon
theres	9	65	2547	3	there_s
thereunto	12	5	265	3	thereunto
weet	7	52	5415	3	w_e_et_
weets	8	54	2772	3	w_e_ets
were	7	62	3833	3	w_ere__
wert	7	97	4982	3	w_er_t_
wheat	11	49	2457	3	whe_at_
wheaten	13	3	640	3	wheaten
wheats	12	50	1322	3	whe_ats
whee	10	54	2959	3	whe_e__
wheel	11	55	1533	3	whe_e_l
wheels	12	38	1171	3	whe_els
wheen	11	50	1605	3	whe_e_n
wheens	12	46	1061	3	whe_ens
wheep	13	62	1435	3	whe_e_p
wheeps	14	43	995	3	whe_eps
wheeze	21	27	681	3	whe_eze
wheezy	24	24	452	3	whe_ezy
wherefore	18	10	390	3	wherefore
wherefrom	20	5	201	3	wherefrom
whereupon	17	7	181	3	whereupon
wherever	17	4	382	3	wherever
wherewith	21	5	271	3	wherewith
wherry	15	47	733	3	wher_ry
wherve	15	56	811	3	wher_ve
wherves	16	54	805	3	wherves
whet	10	51	3378	3	wh__et_
whets	11	50	1961	3	wh__ets
whetted	14	25	669	3	whetted
whetter	13	34	880	3	whetter
wheyey	18	3	432	3	wheye_y
whore	11	60	1804	3	whore__
whored	13	55	1212	3	whore_d
whoredom	17	4	328	3	whoredom
whores	12	56	1710	3	whore_s
whoreson	14	4	401	3	whoreson
whort	11	46	2369	3	whor_t_
whorts	12	51	1143	3	whor_ts

Search took 9 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	134027	0.153	1167915.0
2	DLD Change Limit	134027	98	8.080	16587.5
3	Display Results	98	98	0.030	3266.7
	(SQL Overall)	178691	98	8.263	21625.4