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

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

89 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
theorems	13	4	469	(None)
theorem	12	3	627	1	theorem_
theorbos	13	4	364	2	theorbos
theories	11	3	1159	2	theories
theres	9	65	2547	2	the_re_s
thermes	12	62	1461	2	the_rmes
therms	11	59	1487	2	the_r_ms
cheerers	13	31	954	3	cheerers
chetrums	15	4	391	3	chetrums
chevres	15	37	979	3	chevre_s
chevrets	16	25	532	3	chevrets
choreas	12	44	1420	3	ch_oreas
chores	11	48	2802	3	ch_ore_s
harems	11	55	1382	3	_h_arems
hearers	10	43	1978	3	_hearers
heiress	10	3	681	3	_heiress
heres	8	62	4590	3	_he_re_s
herms	10	56	2643	3	_he_r_ms
heroes	9	49	2383	3	_heroe_s
phellems	15	4	454	3	phellems
phloems	14	3	352	3	phlo_ems
shearers	11	39	1132	3	shearers
shores	9	48	3041	3	sh_ore_s
taborers	10	26	833	3	taborers
taborets	10	27	806	3	taborets
tearers	7	52	1823	3	t_earers
teems	7	60	1978	3	t_e__ems
tenrecs	9	3	603	3	t_enrecs
terms	7	55	2347	3	t_e_r_ms
terrets	7	29	1358	3	t_errets
thairms	12	4	445	3	thair_ms
tharms	11	57	1224	3	th_ar_ms
theaters	11	42	1190	3	theaters
theatres	11	29	864	3	theatre_s
thebes	11	59	1449	3	the_be_s
theines	10	40	1323	3	theine_s
theirs	9	46	1035	3	their__s
theisms	12	3	776	3	the_isms
themes	11	53	1925	3	the_me_s
theocrats	14	6	468	3	theocrats
theologs	12	4	615	3	theologs
theonomy	16	4	454	3	theonomy
theorbo	12	4	374	3	theor_bo
theoretic	14	4	666	3	theoretic
theorise	11	3	787	3	theorise
theorises	12	4	781	3	theorises
theorist	11	4	955	3	theorist
theorists	12	4	660	3	theorists
theorize	20	4	707	3	theorize
theorizers	22	4	333	3	theorizers
theorizes	21	4	707	3	theorizes
theory	12	109	836	3	theor__y
there	8	75	2739	3	the_re__
thereat	10	43	1524	3	the_reat
thereby	15	3	463	3	the_reby
therein	10	23	1035	3	the_rein
theremin	13	10	728	3	the_remin
theremins	14	10	605	3	the_remins
thereof	13	16	806	3	the_reof
thereon	10	19	926	3	the_reon
thereto	10	3	899	3	the_reto
therm	10	60	1802	3	the_r_m_
therme	11	58	1499	3	the_r_me
thermel	12	56	989	3	the_rmel
thermels	13	60	776	3	thermels
thermos	12	46	1075	3	the_rmos
theses	9	65	1797	3	the_se_s
thewless	14	3	392	3	thewless
thioureas	12	11	281	3	thioureas
thirams	12	3	682	3	th_irams
tholes	9	49	1978	3	th_ole_s
thorias	10	23	1205	3	th_orias
thoriums	13	16	640	3	th_oriums
thorns	9	53	1410	3	th_or_ns
thorons	10	45	1191	3	th_orons
thorpes	12	50	1035	3	th_orpes
thorps	11	36	1089	3	th_or_ps
threes	9	71	1732	3	th__rees
throes	9	75	1867	3	thro_e_s
thrones	10	57	1584	3	throne_s
throwers	14	10	603	3	throwers
thrums	11	42	912	3	th__rums
tores	5	53	5267	3	t__ore_s
totems	8	68	1076	3	t__otems
tsores	6	51	1366	3	t_sore_s
tutoress	8	4	509	3	tutoress
whereas	13	44	890	3	whe_reas
wheres	12	59	1744	3	whe_re_s
whores	12	56	1710	3	wh_ore_s

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	146162	0.420	425454.8
2	DLD Change Limit	146162	89	7.126	20511.1
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	7.576	23586.5