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

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

326 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
teraph	11	31	909	(None)
seraph	11	40	1116	1	seraph
ceriph	13	9	846	2	ceriph
gerah	9	3	1530	2	gera_h
graph	11	53	1561	2	_graph
paraph	13	3	1126	2	paraph
serape	8	48	1841	2	serape
seraphs	12	40	809	2	seraphs
teach	10	52	2112	2	te_ach
terai	5	35	2548	2	tera_i
terais	6	40	2351	2	terais
teraohm	12	4	478	2	teraohm
teraphim	15	4	500	2	teraphim
therapy	15	3	661	2	therapy
thrash	12	25	836	2	thrash
torah	8	71	2527	2	tora_h
trap	6	75	3280	2	t_rap_
traps	7	57	2748	2	t_raps
trapt	7	64	3339	2	t_rapt
trash	8	61	1976	2	t_rash
aerate	6	48	3055	3	aerate
agrapha	13	4	513	3	agrapha
beach	12	46	2389	3	be_ach
becap	11	43	1505	3	becap_
becaps	12	38	1140	3	becaps
bedrape	12	7	769	3	bedrape
berake	12	42	1608	3	berake
berate	8	47	2902	3	berate
berth	10	49	1788	3	ber_th
bewrap	13	15	705	3	bewrap_
bewraps	14	13	540	3	bewraps
bewrapt	14	14	713	3	bewrapt
brach	12	61	2330	3	_brach
brash	10	62	2156	3	_brash
breach	13	42	1372	3	breach
breath	11	39	1626	3	breath
caph	11	66	2329	3	__caph
cerate	8	48	2946	3	cerate
ceriphs	14	8	475	3	ceriphs
crap	8	57	3184	3	_crap_
crape	9	61	2844	3	_crape
craps	9	53	2864	3	_craps
crash	10	91	2001	3	_crash
curagh	12	3	655	3	curagh
dearth	10	42	1251	3	dearth
deash	9	56	1724	3	de_ash
death	9	48	2252	3	de_ath
derail	7	42	1881	3	derail
derat	6	50	4408	3	dera_t
derate	7	45	3123	3	derate
derats	7	46	2506	3	derats
deray	9	50	2418	3	dera_y
derays	10	55	1425	3	derays
detach	12	3	1041	3	detach
digraph	14	14	664	3	digraph
drape	8	53	1963	3	_drape
each	9	55	3058	3	_e_ach
earth	8	50	2305	3	_earth
eath	7	57	3566	3	_e_ath
enrapt	8	3	1301	3	enrapt
era	3	57	4150	3	_era__
eras	4	54	4150	3	_era_s
erase	5	49	2549	3	_erase
erupt	7	42	2006	3	_erupt
etape	7	44	1370	3	_etape
feral	8	54	2465	3	fera_l
ferals	9	42	1664	3	ferals
frap	9	59	2581	3	_frap_
fraps	10	56	2055	3	_fraps
gerahs	10	3	941	3	gerahs
grape	8	48	2466	3	_grape
graphs	12	45	1015	3	_graphs
grapy	11	54	1643	3	_grapy
heap	9	64	3289	3	he_ap_
heaps	10	52	2322	3	he_aps
heapy	13	59	1498	3	he_apy
hearth	12	53	1521	3	hearth
heath	11	57	2428	3	he_ath
herald	10	3	1134	3	herald
horah	11	79	2205	3	hora_h
iterant	7	3	1778	3	iterant
iterate	7	11	1911	3	iterate
kaph	13	58	1575	3	__kaph
khaph	17	39	596	3	_khaph
leach	10	54	2252	3	le_ach
leap	6	60	3268	3	le_ap_
leaps	7	55	2293	3	le_aps
leapt	7	50	2747	3	le_apt
leash	8	55	1921	3	le_ash
merch	12	54	1796	3	mer_ch
morph	12	17	1251	3	mor_ph
neap	6	69	2701	3	ne_ap_
neaps	7	56	1832	3	ne_aps
neath	8	60	2028	3	ne_ath
orach	10	52	1923	3	_orach
overapt	12	3	1265	3	overapt
paraphs	14	3	931	3	paraphs
peach	12	54	2249	3	pe_ach
perch	12	45	1883	3	per_ch
perhaps	14	4	612	3	perhaps
periapt	11	3	1341	3	periapt
perish	11	46	1906	3	perish
perp	8	90	2989	3	per_p_
perps	9	55	2148	3	per_ps
preach	13	36	1392	3	preach
rah	6	80	5240	3	__ra_h
ralph	10	7	874	3	__ralph
rap	5	62	6196	3	__rap_
rape	6	50	4163	3	__rape
raphe	10	49	1642	3	__raphe
raps	6	62	4773	3	__raps
rapt	6	72	4531	3	__rapt
rash	7	60	3993	3	__rash
rath	7	60	3766	3	__rath
reach	10	51	2388	3	re_ach
reap	6	59	3474	3	re_ap_
reaps	7	56	2619	3	re_aps
recap	9	57	1802	3	recap_
recaps	10	36	1573	3	recaps
rehash	12	3	743	3	rehash
remap	9	54	1810	3	remap_
remaps	10	50	1287	3	remaps
rerack	12	25	1316	3	rerack
reran	5	73	2910	3	rera_n
retape	8	39	1768	3	retape
rewash	12	3	767	3	rewash
rewrap	11	12	753	3	rewrap_
rewraps	12	13	656	3	rewraps
rewrapt	12	13	811	3	rewrapt
sarape	8	48	1757	3	sarape
scarph	13	42	960	3	scarph
scrap	9	71	2040	3	scrap_
scrape	10	59	1757	3	scrape
scraps	10	60	1724	3	scraps
search	11	33	1242	3	search
selah	8	3	1961	3	sela_h
sera	4	61	4139	3	sera__
serac	7	59	2520	3	sera_c
seracs	8	44	1857	3	seracs
serai	5	68	3016	3	sera_i
serail	6	42	2267	3	serail
serais	6	43	2613	3	serais
seral	5	63	3638	3	sera_l
serapes	9	52	1810	3	serapes
seraphic	15	4	663	3	seraphic
seraphim	15	4	480	3	seraphim
seraphin	13	4	595	3	seraphin
staph	10	43	1465	3	_staph
strap	7	79	2526	3	strap_
straps	8	77	2178	3	straps
strath	9	32	1637	3	strath
surah	8	68	2325	3	sura_h
tach	9	61	3275	3	t__ach
tap	5	76	6387	3	t__ap_
tapa	6	51	2914	3	t__apa
tape	6	45	3814	3	t__ape
taps	6	60	5067	3	t__aps
tarama	8	4	1273	3	tarama
tarp	6	69	3641	3	tar_p_
tarpan	8	28	1429	3	tarpan
tarps	7	65	2711	3	tar_ps
tea	3	73	5332	3	te_a__
teak	8	59	3084	3	te_a_k
teaks	9	42	2290	3	te_aks
teal	4	55	4650	3	te_a_l
teals	5	62	3413	3	te_als
team	6	62	3865	3	te_a_m
teams	7	57	2651	3	te_ams
teapot	8	4	1676	3	te_apot
teapoy	11	3	811	3	te_apoy
tear	4	52	4288	3	te_a_r
teared	7	57	2215	3	teared
tearer	6	48	2290	3	tearer
tears	5	54	3646	3	te_ars
teary	8	51	2405	3	te_ary
teas	4	58	5149	3	te_a_s
tease	5	54	2871	3	te_ase
teat	4	59	6363	3	te_a_t
teats	5	56	3681	3	te_ats
tech	9	59	2544	3	te__ch
teeth	8	73	1585	3	te_eth
tela	4	55	3297	3	tela__
telae	5	43	2329	3	tela_e
telegraph	15	4	514	3	telegraph
temp	8	53	2333	3	te_mp_
tempeh	13	35	746	3	tempeh
tempi	9	49	1220	3	te_mpi
tempo	9	52	1497	3	te_mpo
temps	9	54	1713	3	te_mps
tempt	9	51	2484	3	te_mpt
tenace	8	27	1569	3	tenace
tenail	6	45	1611	3	tenail
tenant	6	3	2247	3	tenant
tench	10	56	2000	3	te_nch
tenth	8	54	2183	3	te_nth
teopan	8	3	935	3	teopan
tepa	6	60	2168	3	te__pa
tepal	7	63	1958	3	tepa_l
tepals	8	54	1504	3	tepals
tepas	7	65	2168	3	tepa_s
teraohms	13	4	370	3	teraohms
terbia	8	3	1115	3	terbia
terbic	10	4	1096	3	terbic
terce	7	57	2184	3	ter_ce
tercel	8	36	1299	3	tercel
terces	8	39	2141	3	terces
tercet	8	36	2491	3	tercet
teredo	7	3	1078	3	teredo
terefah	13	4	411	3	terefah
terete	6	3	1933	3	terete
terga	6	33	1564	3	ter_ga
tergal	7	29	1283	3	tergal
tergum	9	3	793	3	tergum
term	6	62	3315	3	ter__m
termed	9	48	1670	3	termed
termer	8	57	1725	3	termer
termly	11	3	843	3	termly
termor	8	44	1251	3	termor
terms	7	55	2347	3	ter_ms
tern	4	61	3480	3	ter__n
ternary	10	3	834	3	ternary
ternate	7	4	1548	3	ternate
terne	5	64	2615	3	ter_ne
ternes	6	54	2290	3	ternes
terns	5	52	2687	3	ter_ns
terra	5	44	1966	3	ter_ra
terrace	9	33	1184	3	terrace
terrae	6	29	1521	3	terrae
terrain	7	4	1085	3	terrain
terrane	7	28	1423	3	terrane
terrapin	10	4	620	3	terrapin
terras	6	35	1697	3	terras
terret	6	34	2562	3	terret
territ	6	34	2137	3	territ
terror	6	38	1173	3	terror
terry	8	47	2187	3	ter_ry
terse	5	50	2682	3	ter_se
terser	6	73	1782	3	terser
tetany	9	5	984	3	tetany
teth	7	63	2789	3	te__th
tetra	5	34	1795	3	tetra__
tetrad	7	36	1205	3	tetra_d
tetrads	8	29	1019	3	tetrads
tetrapod	11	4	512	3	tetrapod
tetrarch	13	10	478	3	tetrarch
tetras	6	30	1762	3	tetra_s
teuch	10	52	1485	3	te_uch
teugh	9	55	1161	3	te_ugh
texas	12	65	1493	3	texa_s
thrall	9	38	1029	3	thrall
thrave	12	60	1027	3	thrave
thraw	11	105	1592	3	thra_w
thrawn	12	76	942	3	thrawn
thraws	12	92	1110	3	thraws
threap	11	56	966	3	threap_
threaps	12	48	864	3	threaps
thresh	12	27	686	3	thresh
thrip	10	30	1218	3	thrip_
thrips	11	29	901	3	thrips
thrush	12	25	748	3	thrush
tirade	7	3	1169	3	tirade
toecap	10	3	732	3	toecap_
toecaps	11	3	555	3	toecaps
toph	9	63	2687	3	t__oph
tora	4	75	4599	3	tora__
torahs	9	51	1564	3	torahs
toras	5	55	4037	3	tora_s
torch	10	74	2093	3	tor_ch
toroth	9	55	1296	3	toroth
trace	7	58	2961	3	t_race
track	11	48	2301	3	t_rack
tract	7	56	3571	3	t_ract
trad	5	56	3091	3	t_ra_d
trade	6	50	2604	3	t_rade
tragi	6	47	1717	3	t_ragi
traik	9	54	1820	3	t_raik
trail	5	51	2677	3	t_rail
train	5	65	2911	3	t_rain
trait	5	69	4084	3	t_rait
tram	6	70	3455	3	t_ra_m
tramp	9	63	1977	3	t_ramp
tramps	10	51	1445	3	t_ramps
trampy	13	49	925	3	t_rampy
trams	7	53	2767	3	t_rams
trank	9	62	2242	3	t_rank
tranq	14	54	1689	3	t_ranq
trans	5	49	3304	3	t_rans
trapan	8	24	1297	3	t_rapan
trapes	8	50	2446	3	t_rapes
trashy	12	50	905	3	t_rashy
trass	5	62	2647	3	t_rass
trave	8	52	2303	3	t_rave
trawl	8	49	1587	3	t_rawl
tray	7	76	3259	3	t_ra_y
trays	8	56	2343	3	t_rays
tread	6	48	2170	3	trea_d
treads	7	48	1792	3	treads
treat	5	62	4035	3	trea_t
treats	6	48	2169	3	treats
treaty	9	44	1435	3	treaty
trefah	12	3	509	3	trefah
trench	11	42	1161	3	trench
trepan	8	25	1167	3	trepan
trigraph	14	4	570	3	trigraph
trip	6	68	3039	3	t_rip_
tripe	7	54	2538	3	t_ripe
trips	7	49	2336	3	t_rips
trop	6	68	3330	3	t_rop_
trope	7	57	2580	3	t_rope
trophy	14	3	828	3	t_rophy
troth	8	56	2220	3	t_roth
truth	8	52	1415	3	t_ruth
turaco	8	3	945	3	turaco
turps	7	49	1873	3	tur_ps
twerp	10	39	841	3	twer_p_
twerps	11	34	515	3	twer_ps
tyrant	9	3	1533	3	tyrant
vera	7	68	2884	3	vera__
wrap	9	68	2197	3	_wrap_
wraps	10	56	1715	3	_wraps
wrapt	10	51	2318	3	_wrapt
wrath	11	57	1587	3	_wrath
wreath	12	41	1119	3	wreath
xerarch	19	4	384	3	xerarch
yeah	10	67	2541	3	ye_a_h
zeroth	18	3	796	3	zeroth

Search took 7 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	112716	0.500	357382.0
2	DLD Change Limit	112716	326	5.390	20912.1
3	Display Results	326	326	0.110	2963.6
	(SQL Overall)	178691	326	6.000	29781.8