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

Here are the results of your fuzzy-string dictionary search for “warped” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

172 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
warped	12	48	1641	(None)
carped	11	59	2376	1	carped
harped	12	44	1840	1	harped
wapped	14	44	1647	1	wapped
warded	11	50	2104	1	warded
wared	9	63	3987	1	war_ed
warked	14	44	2121	1	warked
warmed	12	45	1689	1	warmed
warned	10	40	1891	1	warned
warper	11	40	1558	1	warper
warred	10	40	1984	1	warred
warted	10	42	2323	1	warted
amped	10	48	2051	2	_amped
aped	7	85	3815	2	_a_ped
arced	8	82	2416	2	_arced
armed	8	63	2443	2	_armed
arpen	7	44	1804	2	_arpen
awarded	12	3	622	2	awarded
barbed	11	51	2131	2	barbed
barded	10	54	2642	2	barded
bared	8	51	4448	2	bar_ed
barfed	12	54	1638	2	barfed
barged	10	58	2264	2	barged
barked	13	50	2731	2	barked
barned	9	56	2358	2	barned
barred	9	57	2579	2	barred
burped	11	62	1550	2	burped
camped	13	47	2023	2	camped
caped	10	49	3180	2	ca_ped
capped	13	47	2185	2	capped
carded	10	54	2490	2	carded
cared	8	60	5009	2	car_ed
caried	9	45	2869	2	caried
carked	13	40	2482	2	carked
carpel	10	54	1847	2	carpel
carper	10	49	2363	2	carper
carpet	10	45	3009	2	carpet
carted	9	86	3144	2	carted
carved	12	43	2085	2	carved
craped	11	61	2052	2	craped
damped	12	43	1558	2	damped
dapped	12	45	1676	2	dapped
dared	7	59	3501	2	dar_ed
darked	12	39	1963	2	darked
darned	8	50	1848	2	darned
darted	8	46	2092	2	darted
draped	10	53	1436	2	draped
dwarfed	15	3	348	2	dwarfed
eared	6	51	3950	2	ear_ed
earned	7	48	1833	2	earned
farced	12	52	1653	2	farced
farded	11	45	1895	2	farded
fared	9	58	4234	2	far_ed
farmed	12	51	1765	2	farmed
farted	10	51	2178	2	farted
gaped	9	61	2353	2	ga_ped
gapped	12	42	1712	2	gapped
garbed	10	48	1566	2	garbed
garred	8	52	1740	2	garred
gasped	10	48	1429	2	gasped
gawped	13	50	907	2	gawped
happed	14	48	2010	2	happed
hared	9	57	4218	2	har_ed
harked	14	54	2255	2	harked
harmed	12	52	1883	2	harmed
harper	11	50	1840	2	harper
hasped	12	50	1444	2	hasped
japed	15	62	1763	2	ja_ped
jarred	14	46	1325	2	jarred
jauped	16	45	790	2	jauped
lamped	11	40	1754	2	lamped
lapped	11	43	2003	2	lapped
larded	8	43	1909	2	larded
larked	11	45	1947	2	larked
mapped	13	40	1588	2	mapped
marked	13	39	2162	2	marked
marled	9	55	2316	2	marled
marred	9	54	2104	2	marred
marted	9	44	2521	2	marted
napped	11	42	1816	2	napped
narked	11	41	1674	2	narked
oared	6	50	3065	2	oar_ed
palped	11	45	1364	2	palped
pared	8	69	4676	2	par_ed
parged	10	49	2203	2	parged
parked	13	44	2513	2	parked
parled	9	46	2627	2	parled
parred	9	50	2407	2	parred
parsed	9	63	2389	2	parsed
parted	9	42	2868	2	parted
ramped	11	46	1790	2	ramped
raped	8	53	3462	2	ra_ped
rapped	11	41	2268	2	rapped
rared	6	57	3832	2	rar_ed
rasped	9	47	1520	2	rasped
sapped	11	44	2201	2	sapped
scarped	12	43	1439	2	scarped
sharped	13	41	1204	2	sharped
swamped	15	49	844	2	swamped
swapped	15	42	914	2	swapped
swarded	12	3	815	2	swarded
swarmed	13	6	748	2	swarmed
tamped	11	43	1704	2	tamped
taped	8	53	2742	2	ta_ped
tapped	11	38	2005	2	tapped
tared	6	93	4005	2	tar_ed
tarred	7	47	2028	2	tarred
tarted	7	49	2337	2	tarted
unwarped	14	3	687	2	unwarped
urped	8	46	1528	2	_urped
vamped	14	42	1101	2	vamped
varied	10	48	1786	2	varied
varved	13	41	1060	2	varved
wadded	12	40	1417	2	wadded
waded	10	60	2475	2	wa_ded
waffed	16	45	979	2	waffed
wafted	13	40	1214	2	wafted
waged	10	48	2278	2	wa_ged
wagged	12	46	1612	2	wagged
waifed	13	40	1103	2	waifed
wailed	10	48	2359	2	wailed
waired	10	60	1583	2	waired
waited	10	38	1977	2	waited
waived	13	45	1128	2	waived
waked	13	56	2675	2	wa_ked
waled	9	43	3099	2	wa_led
walked	14	53	1378	2	walked
walled	10	40	2129	2	walled
waned	9	58	3178	2	wa_ned
wanked	14	45	1715	2	wanked
wanned	10	43	1801	2	wanned
wanted	10	43	1972	2	wanted
warbled	13	32	1216	2	warbled
ward	8	65	4225	2	war__d
warden	10	45	1551	2	warden
warder	10	40	2027	2	warder
ware	7	62	5472	2	war_e_
wares	8	82	5058	2	war_es
warhead	14	3	660	2	warhead
warier	9	37	2289	2	warier
warmer	11	38	1673	2	warmer
warner	9	37	1722	2	warner
warp	9	56	3500	2	warp__
warpers	12	34	1358	2	warpers
warps	10	71	2642	2	warp_s
warren	9	50	1285	2	warren
warsled	11	29	1044	2	warsled
washed	13	55	2150	2	washed
wasted	10	44	2302	2	wasted
wauked	14	42	1057	2	wauked
wauled	10	47	1396	2	wauled
waved	12	52	2358	2	wa_ved
wawled	13	38	1170	2	wawled
waxed	16	60	1848	2	wa_xed
wearied	11	29	1180	2	wearied
whapped	18	36	757	2	whapped
wharfed	17	3	441	2	wharfed
wimped	14	42	1151	2	wimped
wiped	11	47	2208	2	w_iped
wired	9	53	2764	2	wir_ed
wisped	12	34	1189	2	wisped
worded	11	43	1662	2	worded
worked	14	53	1470	2	worked
wormed	12	43	1430	2	wormed
wrapped	15	33	802	2	wrapped
wried	9	55	1856	2	w_ried
yapped	14	44	1514	2	yapped
yarded	11	47	1402	2	yarded
yarned	10	55	1402	2	yarned
yauped	12	40	833	2	yauped
yawped	15	52	810	2	yawped
zapped	20	42	1352	2	zapped

Search took 6 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	82551	0.123	1452772.4
2	DLD Change Limit	82551	172	4.940	16710.7
3	Display Results	172	172	0.046	3739.1
	(SQL Overall)	178691	172	5.109	34975.7