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

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

337 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
umiaq	16	5	681	(None)
umiac	9	3	895	1	umiac
umiak	11	3	766	1	umiak
umiaqs	17	3	300	1	umiaqs
amia	6	68	3689	2	amia_
amias	7	58	3146	2	amias
umiack	14	3	517	2	umiack
umiacs	10	3	566	2	umiacs
umiaks	12	4	495	2	umiaks
urial	5	48	2302	2	urial
alias	5	58	3460	3	alias
ama	5	108	5330	3	am_a_
amah	9	89	2748	3	am_ah
amain	7	49	2288	3	amain
amas	6	77	4629	3	am_as
ami	5	66	4680	3	ami__
amice	9	61	2286	3	amice
amici	9	42	1738	3	amici
amid	7	70	3633	3	ami_d
amide	8	61	2847	3	amide
amido	8	57	2096	3	amido
amids	8	56	2750	3	amids
amie	6	63	3984	3	ami_e
amies	7	68	3768	3	amies
amiga	8	55	1479	3	amiga
amigas	9	59	1216	3	amigas
amigo	8	65	1545	3	amigo
amin	6	60	4224	3	ami_n
amine	7	58	3537	3	amine
amino	7	54	2549	3	amino
amins	7	55	3431	3	amins
amir	6	51	2974	3	ami_r
amirs	7	59	2491	3	amirs
amis	6	64	4531	3	ami_s
amiss	7	58	2306	3	amiss
amity	10	4	1608	3	amity
amnia	7	59	1863	3	amnia_
apian	7	50	1833	3	apian
aria	4	62	4542	3	aria_
arias	5	54	3802	3	arias
audial	7	3	1299	3	audial
avian	8	46	1605	3	avian
axial	12	45	1519	3	axial
bias	6	47	3815	3	_bias
bima	8	67	2382	3	bima_
bimah	12	70	1326	3	bimah
bimas	9	55	2174	3	bimas
briar	7	57	1815	3	briar
burial	8	41	1762	3	burial
chia	9	60	2662	3	chia_
chiao	10	56	1836	3	chiao
chias	10	46	2551	3	chias
ciao	6	49	2418	3	_ciao
cumbia	12	37	988	3	cumbia_
cumbias	13	33	895	3	cumbias
cumin	9	46	1697	3	cumi_n
cumins	10	33	1493	3	cumins
curia	7	45	2376	3	curia_
curiae	8	45	1837	3	curiae
curial	8	40	1915	3	curial
dial	5	59	3506	3	_dial
dulia	6	10	1498	3	dulia_
dulias	7	12	1274	3	dulias
duma	7	55	2445	3	dum_a_
dumas	8	54	2043	3	dum_as
dumka	12	43	883	3	dumka_
durian	7	3	1200	3	durian
email	7	47	1509	3	email
embar	9	40	1159	3	embar
embay	12	34	1059	3	embay
emic	8	64	2274	3	emi_c
emir	6	59	1869	3	emi_r
emirs	7	61	1615	3	emirs
emit	6	54	3841	3	emi_t
emits	7	54	2146	3	emits
fiar	7	64	2733	3	_fiar
fiat	7	66	4664	3	_fiat
friar	8	54	1427	3	friar
fumier	11	3	1090	3	fumier
fuming	12	40	1329	3	fuming
glia	5	64	2315	3	glia_
glial	6	67	1543	3	glial
glias	6	46	1849	3	glias
guaiac	9	4	615	3	guaiac
gumma	10	53	1310	3	gumma_
gummas	11	48	1051	3	gummas
human	10	27	1603	3	hum_an
humic	12	41	1324	3	humi_c
humid	11	42	1376	3	humi_d
ilia	4	60	2681	3	ilia_
iliac	7	50	1348	3	iliac
iliad	6	46	1345	3	iliad
ilial	5	53	1783	3	ilial
imam	8	17	1832	3	im_am
imid	7	61	2227	3	imi_d
imide	8	57	1687	3	imide
imido	8	58	1222	3	imido
imids	8	60	1512	3	imids
imine	7	58	2104	3	imine
imino	7	43	1521	3	imino
inia	4	50	2469	3	inia_
ixia	11	57	1320	3	ixia_
ixias	12	48	836	3	ixias
jiao	11	50	1784	3	_jiao
jumbal	17	5	846	3	jumbal
kaiak	8	3	1035	3	kaiak
kumiss	12	3	592	3	kumiss
lamia	7	53	2432	3	lamia_
lamiae	8	48	1745	3	lamiae
lamias	8	50	2061	3	lamias
liar	4	72	2968	3	_liar
lima	6	57	3413	3	lima_
liman	7	59	2160	3	liman
limas	7	56	2763	3	limas
luma	6	55	2752	3	lum_a_
lumas	7	56	2291	3	lum_as
lumbar	10	36	1059	3	lumbar
lumina	8	46	1354	3	lumina
luminal	9	37	1100	3	luminal
ma	4	100	6065	3	_m_a_
maar	6	60	2505	3	_maar
mac	7	80	5392	3	_m_ac
mad	6	89	5870	3	_m_ad
mae	5	76	5910	3	_m_ae
mag	6	79	5647	3	_m_ag
maid	7	55	3763	3	_maid
mail	6	55	4343	3	_mail
maim	8	58	3147	3	_maim
main	6	53	4550	3	_main
mair	6	61	3376	3	_mair
man	5	74	6585	3	_m_an
map	7	72	5511	3	_m_ap
mar	5	79	6594	3	_m_ar
mas	5	81	7581	3	_m_as
mat	5	80	8393	3	_m_at
maw	8	70	5009	3	_m_aw
max	12	90	4544	3	_m_ax
may	8	87	5762	3	_m_ay
mead	7	55	3160	3	_mead
meal	6	56	4317	3	_meal
mean	6	55	3808	3	_mean
meat	6	63	5960	3	_meat
mi	4	82	4904	3	_mi__
miaou	7	5	1308	3	_miaou
miaow	10	5	835	3	_miaow
miasm	9	12	1109	3	_miasm
miaul	7	16	1212	3	_miaul
mib	7	69	4610	3	_mi_b
mibs	8	53	3046	3	_mibs
mic	7	76	4763	3	_mi_c
mica	8	64	2824	3	_mica
micas	9	68	2305	3	_micas
mice	8	74	4222	3	_mice
mick	12	63	3342	3	_mick
mics	8	74	3514	3	_mics
mid	6	73	5445	3	_mi_d
midi	7	56	2846	3	_midi
mids	7	65	4177	3	_mids
mien	6	50	2835	3	_mien
miff	12	56	2504	3	_miff
mig	6	56	4607	3	_mi_g
migg	8	57	1679	3	_migg
migs	7	69	3531	3	_migs
mike	10	55	3528	3	_mike
mil	5	57	5210	3	_mi_l
mild	7	53	3084	3	_mild
mile	6	63	5256	3	_mile
milk	10	50	2846	3	_milk
mill	6	65	4147	3	_mill
milo	6	55	3609	3	_milo
mils	6	60	4532	3	_mils
milt	6	54	5580	3	_milt
mim	7	60	4841	3	_mi_m
mime	8	57	3639	3	_mime
mina	6	51	3690	3	_mina
minae	7	56	2772	3	_minae
minas	7	54	3411	3	_minas
mind	7	54	3436	3	_mind
mine	6	72	5615	3	_mine
mini	6	56	3454	3	_mini
mink	10	66	3651	3	_mink
mint	6	67	5804	3	_mint
minx	13	77	2333	3	_minx
mips	8	55	3407	3	_mips
mir	5	70	4676	3	_mi_r
mire	6	67	4822	3	_mire
miri	6	67	3036	3	_miri
mirk	10	67	2949	3	_mirk
mirs	6	69	4056	3	_mirs
miry	9	63	2674	3	_miry
mis	5	81	6261	3	_mi_s
mise	6	60	4357	3	_mise
miso	6	72	2989	3	_miso
miss	6	53	3941	3	_miss
mist	6	61	5452	3	_mist
mite	6	62	4940	3	_mite
mitt	6	61	4548	3	_mitt
mity	9	55	2820	3	_mity
mix	12	61	3817	3	_mi_x
mixt	13	68	3191	3	_mixt
moa	5	72	4918	3	_moa_
moan	6	58	3201	3	_moan
moas	6	55	4534	3	_moas
moat	6	63	5203	3	_moat
mura	6	56	3329	3	mura_
mural	7	52	2510	3	mural
muras	7	53	2956	3	muras
naiad	6	3	1340	3	naiad
nubia	7	3	1122	3	nubia_
nubias	8	3	1008	3	nubias
numbat	10	3	1208	3	numbat
numina	8	35	1084	3	numina
obia	6	79	2310	3	obia_
obias	7	61	1685	3	obias
ohia	7	57	1936	3	ohia_
ohias	8	44	1556	3	ohias
omit	6	53	3736	3	omi_t
omits	7	50	1825	3	omits
oomiac	10	3	706	3	oomiac
oomiak	12	3	535	3	oomiak
phial	10	3	1320	3	phial
pia	5	68	4803	3	_pia_
pial	6	56	3670	3	_pial
pian	6	61	3609	3	_pian
pias	6	65	4255	3	_pias
pima	8	54	2865	3	pima_
pimas	9	47	2510	3	pimas
puma	8	54	2412	3	pum_a_
pumas	9	51	2156	3	pum_as
pumice	12	3	822	3	pumice
raia	4	66	3838	3	raia_
raias	5	46	3112	3	raias
ria	3	67	4550	3	_ria_
rial	4	59	3809	3	_rial
rias	4	55	4059	3	_rias
rumba	9	36	1251	3	rumba_
rumbas	10	25	1201	3	rumbas
rumina	8	34	1248	3	rumina
ruminal	9	28	999	3	ruminal
rupiah	11	4	621	3	rupiah
sial	4	59	3883	3	_sial
sima	6	47	3078	3	sima_
simar	7	49	2081	3	simar
simas	7	57	2755	3	simas
simian	8	8	1115	3	simian
smear	7	44	1639	3	smear
smilax	15	3	539	3	smilax
smile	7	48	2391	3	smile
smirk	11	66	1274	3	smirk
smit	6	51	3840	3	smi_t
smite	7	52	2486	3	smite
smith	10	78	1804	3	smith
sumac	9	95	1488	3	sum_ac
summa	9	47	1331	3	summa_
summae	10	39	1101	3	summae
summas	10	43	1316	3	summas
triac	7	41	1637	3	triac
triad	6	52	1772	3	triad
trial	5	49	2635	3	trial
tumid	8	41	1402	3	tumi_d
uhlan	8	4	911	3	uhlan
ulan	4	65	2739	3	u_lan
ulna	4	63	1732	3	ulna_
ulnad	6	56	1145	3	ulnad
ulnae	5	52	1457	3	ulnae
ulnar	5	60	1398	3	ulnar
ulnas	5	57	1653	3	ulnas
ulpan	7	3	1012	3	ulpan
ulva	7	54	1269	3	ulva_
ulvas	8	45	1150	3	ulvas
um	4	73	3883	3	um___
umami	9	3	988	3	umami
umbel	9	36	1283	3	umbel
umber	9	46	1758	3	umber
umbo	8	55	1665	3	um_bo
umbos	9	46	1306	3	umbos
umbra	9	4	850	3	umbra
umbrae	10	3	867	3	umbrae
umbral	10	3	862	3	umbral
umbras	10	3	863	3	umbras
umiacks	15	3	401	3	umiacks
umlaut	8	3	803	3	umlaut
umm	7	119	2126	3	um__m
ump	7	61	3044	3	um__p
umped	10	47	1727	3	umped
umping	11	48	1532	3	umping
umpire	10	4	788	3	umpire
umps	8	57	2194	3	um_ps
unai	4	48	2478	3	u_nai
unais	5	34	2077	3	unais
unau	4	39	2415	3	u_nau
unban	7	21	1433	3	unban
unbar	7	19	1361	3	unbar
uncap	9	3	1228	3	uncap
uncia	7	50	1516	3	uncia_
unciae	8	32	1531	3	unciae
uncial	8	37	1522	3	uncial
unhat	8	11	1926	3	unhat
unify	11	36	1111	3	unify
union	5	45	1979	3	union
unit	4	51	4007	3	uni_t
unite	5	48	2838	3	unite
units	5	49	2343	3	units
unity	8	49	1849	3	unity
unjam	14	4	872	3	unjam
unlay	8	46	1370	3	unlay
unman	7	27	1542	3	unman
unmix	14	38	897	3	unmi_x
unmixt	15	37	870	3	unmixt
unsay	8	32	1284	3	unsay
upas	6	83	2238	3	u_pas
urban	7	20	1386	3	urban
urbia	7	3	1113	3	urbia_
urbias	8	3	908	3	urbias
urea	4	65	2805	3	urea_
ureal	5	67	2268	3	ureal
ureas	5	58	2601	3	ureas
uremia	8	29	1089	3	uremia_
uremias	9	24	950	3	uremias
urials	6	44	1519	3	urials
uric	6	36	2493	3	uri_c
urinal	6	6	1412	3	urinal
urine	5	50	2659	3	urine
ursa	4	41	1690	3	ursa_
ursae	5	52	1445	3	ursae
using	6	63	1796	3	using
usual	5	3	1018	3	usual
uta	3	74	2558	3	u_ta_
utas	4	59	2495	3	u_tas
utile	5	47	1893	3	utile
uvea	7	47	1265	3	uvea_
uveal	8	44	1107	3	uveal
uveas	8	49	1228	3	uveas
via	6	56	3624	3	_via_
vial	7	67	3109	3	_vial
zamia	16	51	1521	3	zamia_
zamias	17	42	1292	3	zamias

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	83667	0.220	812231.8
2	DLD Change Limit	83667	337	6.093	13731.7
3	Display Results	337	337	0.093	3623.7
	(SQL Overall)	178691	337	6.406	27894.3