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

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

102 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
ureal	5	67	2268	(None)
areal	5	59	2874	1	areal
real	4	57	5029	1	_real
unreal	6	44	1445	1	unreal
urea	4	65	2806	1	urea_
ureas	5	58	2601	1	ureas
urial	5	48	2302	1	urial
uveal	8	44	1107	1	uveal
area	4	58	4340	2	area_
areae	5	52	2975	2	areae
areas	5	59	3579	2	areas
argal	6	50	2340	2	argal
artal	5	55	2548	2	artal
arval	8	60	1702	2	arval
aural	5	44	2896	2	aur_al
boreal	8	48	1721	2	boreal
bread	8	55	2311	2	bread
break	11	53	1940	2	break
bream	9	51	2181	2	bream
bureau	8	7	1252	2	bureau
burial	8	41	1762	2	burial
bursal	8	44	1482	2	bursal
cereal	8	3	1583	2	cereal
craal	7	41	1775	2	craal
creak	11	54	1843	2	creak
cream	9	57	2135	2	cream
credal	9	3	1167	2	credal
creel	7	51	2148	2	creel
cuneal	8	6	1151	2	cuneal
curial	8	40	1915	2	curial
curtal	8	39	1454	2	curtal
deal	5	63	4741	2	_deal
dread	7	44	1902	2	dread
dream	8	51	2039	2	dream
drear	6	50	1690	2	drear
dural	6	49	2389	2	dur_al
feal	7	139	4042	2	_feal
feral	8	54	2465	2	feral
freak	12	51	1524	2	freak
graal	6	43	1650	2	graal
great	6	60	3424	2	great
heal	7	56	4569	2	_heal
ideal	6	57	1639	2	ideal
ileal	5	61	1808	2	ileal
irreal	6	5	783	2	irreal
jural	12	51	2048	2	jur_al
jurel	12	45	1633	2	jure_l
kraal	9	45	1183	2	kraal
leal	4	60	4327	2	_leal
loreal	6	38	1431	2	loreal
luteal	6	44	1148	2	luteal
meal	6	56	4317	2	_meal
mural	7	52	2511	2	mur_al
oral	4	76	3812	2	or_al
ordeal	7	7	925	2	ordeal
oread	6	46	1960	2	oread
peal	6	86	4810	2	_peal
read	5	59	4253	2	_read
realm	7	56	2162	2	_realm
reals	5	50	3865	2	_reals
ream	6	58	4161	2	_ream
reap	6	59	3474	2	_reap
rear	4	56	4455	2	_rear
reel	4	52	4053	2	_reel
regal	6	50	2379	2	_regal
renal	5	59	2951	2	_renal
rial	4	59	3810	2	_rial
rugal	6	59	1609	2	rugal
rural	5	58	2117	2	rural
seal	4	56	5437	2	_seal
seral	5	63	3638	2	seral
sheal	8	49	2770	2	sheal
steal	5	61	2547	2	steal
sural	5	59	3126	2	sur_al
surreal	7	3	923	2	surreal
teal	4	55	4650	2	_teal
tread	6	48	2170	2	tread
treat	5	62	4035	2	treat
trial	5	49	2635	2	trial
unread	7	34	1267	2	unread
unreel	6	36	1293	2	unreel
unseal	6	33	1547	2	unseal
uprear	8	16	879	2	uprear
uraei	5	30	1608	2	uraei
urban	7	20	1386	2	urban
urease	6	45	1699	2	urease
uredial	8	29	1048	2	uredial
uredo	6	51	1299	2	uredo
ureic	7	45	1446	2	ureic
urials	6	44	1519	2	urials
urinal	6	6	1412	2	urinal
ursa	4	41	1691	2	ursa_
ursae	5	52	1445	2	ursae
usual	5	3	1018	2	usual
uvea	7	47	1265	2	uvea_
uveas	8	49	1228	2	uveas
veal	7	69	3681	2	_veal
weal	7	58	3868	2	_weal
wheal	11	57	1618	2	wheal
wreak	12	55	1327	2	wreak
zeal	13	55	3033	2	_zeal
zoeal	14	48	1378	2	zoeal

Search took 2 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	53800	0.296	603685.8
2	DLD Change Limit	53800	102	1.640	32804.9
3	Display Results	102	102	0.033	3090.9
	(SQL Overall)	178691	102	1.969	90752.2