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

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

306 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
umpires	11	3	781	(None)
empires	11	3	985	1	empires
umpire	10	4	788	1	umpire_
umpired	12	3	578	1	umpired
amperes	11	3	1398	2	amperes
aspires	9	6	1204	2	aspires
empire	10	3	931	2	empire_
expires	16	3	868	2	expires
mires	7	56	4088	2	_m_ires
moires	8	9	1563	2	_moires
spires	8	46	2811	2	_spires
suspires	10	3	820	2	suspires
umpirages	14	4	334	2	umpirages
unpiles	9	21	1278	2	unpiles
uppiles	11	20	826	2	uppiles
vampires	15	22	603	2	vampires
admires	10	3	866	3	admires
alpines	9	40	1619	3	alpines
ambries	11	16	1453	3	ambries
amices	10	50	1801	3	am_ices
amides	9	57	2266	3	am_ides
amies	7	68	3768	3	am_i_es
amines	8	47	2798	3	am_ines
amirs	7	59	2491	3	am_ir_s
ammines	11	3	1267	3	ammines
ampere	10	5	1441	3	ampere_
ampules	11	8	943	3	ampules
apices	10	49	1626	3	_apices
apres	7	54	2640	3	_ap_res
armoires	10	5	762	3	armoires
aspire	8	6	1212	3	aspire_
aspired	10	6	817	3	aspired
aspirer	9	6	790	3	aspirer
aspirers	10	6	649	3	aspirers
aspises	9	6	1164	3	aspises
attires	7	23	1295	3	attires
auspices	12	3	644	3	auspices
bemires	11	32	1283	3	bemires
bumpered	15	3	600	3	bumpered
bumpers	13	39	1205	3	bumper_s
bumpier	13	35	920	3	bumpi_er
bumpiest	14	3	787	3	bumpi_est
bumpiness	15	3	528	3	bumpiness
buppies	13	30	1106	3	buppi_es
campfires	18	4	412	3	campfires
camphires	18	4	578	3	camphires
capizes	20	4	1037	3	capizes
cires	7	49	3291	3	__cires
compares	14	38	1643	3	compares
comperes	14	32	1797	3	comperes
compiles	14	3	1198	3	compiles
copiers	11	42	1596	3	copiers
copies	10	41	3030	3	copi_es
cuspides	13	30	694	3	cuspides
cypres	13	3	852	3	cyp_res
desires	8	13	1613	3	desires
drumfires	15	4	255	3	drumfires
dummies	12	30	1213	3	dummi_es
dumpers	12	34	1266	3	dumper_s
dumpier	12	40	965	3	dumpi_er
dumpiest	13	3	874	3	dumpi_est
dumpiness	14	3	565	3	dumpiness
dumpings	14	29	576	3	dumpings
dumpsites	14	4	376	3	dumpsites
emeries	9	16	2002	3	emeries
emigres	10	3	767	3	emigres
emirs	7	61	1615	3	em_ir_s
empales	11	24	1143	3	empales
emperies	12	3	1456	3	emperies
empiric	13	4	596	3	empiric
empirics	14	4	400	3	empirics
empress	11	3	816	3	emp_ress
emprise	11	3	1072	3	emprise
emprises	12	3	1100	3	emprises
emprizes	21	3	813	3	emprizes
emptiers	12	7	519	3	emptiers
empties	11	7	1224	3	empties
entires	7	15	1778	3	entires
espies	8	37	1680	3	espi_es
expire	15	3	802	3	expire_
expired	17	3	640	3	expired
expirer	16	3	599	3	expirer
expirers	17	3	512	3	expirers
expiries	17	4	775	3	expiries
fires	8	57	4075	3	__fires
glaires	8	40	1013	3	glaires
guipures	11	4	373	3	guipures
gumlines	11	23	857	3	gumlines
gummites	13	4	616	3	gummites
gunfires	12	3	506	3	gunfires
guppies	12	33	1052	3	guppi_es
hires	8	61	3434	3	__hires
huipiles	13	4	442	3	huipiles
humpers	14	27	1352	3	humper_s
humpier	14	31	1072	3	humpi_er
humpiest	15	3	896	3	humpi_est
humpiness	16	3	577	3	humpiness
imbibes	13	3	467	3	imbibes
imides	9	45	1533	3	im_ides
imines	8	49	1834	3	im_ines
immies	10	24	1242	3	immi_es
immixes	18	3	506	3	immixes
immures	11	3	671	3	immures
impaired	13	3	514	3	impaired
impairer	12	4	486	3	impairer
impairers	13	4	371	3	impairers
impairs	11	3	581	3	impair_s
impales	11	33	1176	3	impales
imparks	15	27	666	3	imparks
imparts	11	29	853	3	imparts
impedes	12	43	1009	3	impedes
imphees	14	3	669	3	imphees
impinges	13	29	742	3	impinges
impings	12	34	854	3	impings
impious	11	3	705	3	impious
impis	9	62	1383	3	impi__s
implies	11	3	1211	3	implies
implores	12	12	704	3	implores
impones	11	27	1225	3	impones
imports	11	30	962	3	imports
imposes	11	32	1368	3	imposes
impresa	11	3	475	3	imp_resa
imprese	11	3	814	3	imp_rese
impress	11	3	777	3	imp_ress
imprest	11	3	1020	3	imp_rest
impure	10	3	837	3	impure_
impurer	11	3	648	3	impurer
impurest	12	4	591	3	impurest
imputes	11	3	808	3	imputes
inspires	10	3	762	3	inspires
ires	4	56	3928	3	___ires
jumpers	18	39	984	3	jumper_s
jumpier	18	31	794	3	jumpi_er
jumpiest	19	3	686	3	jumpi_est
jumpiness	20	3	429	3	jumpiness
lapides	10	30	1204	3	lapides
lapises	9	35	1346	3	lapises
lempiras	12	4	385	3	lempiras
lipides	10	38	1062	3	lipides
lumpers	11	35	1448	3	lumper_s
lumpier	11	34	1014	3	lumpi_er
lumpiest	12	3	925	3	lumpi_est
lumpiness	13	3	648	3	lumpiness
lupines	9	39	1250	3	lupines
madres	9	37	1818	3	_madres
mailes	8	43	2911	3	_mailes
mairs	7	62	2829	3	_mair_s
maizes	17	51	1573	3	_maizes
mares	7	64	5763	3	_m_ares
matres	8	45	2223	3	_matres
mbiras	10	7	714	3	_mbiras
meres	7	51	4357	3	_m_eres
metres	8	51	2156	3	_metres
mikes	11	51	2989	3	_m_ikes
miles	7	46	4507	3	_m_iles
mimes	9	57	3202	3	_m_imes
mines	7	56	5195	3	_m_ines
mire	6	67	4822	3	_m_ire_
mired	8	57	2922	3	_m_ired
mirex	14	68	1662	3	_m_irex
mirks	11	51	2214	3	_m_irks
mirs	6	69	4056	3	_m_ir_s
mises	7	47	4056	3	_m_ises
mites	7	51	4180	3	_m_ites
mitres	8	39	2207	3	_mitres
mixes	14	72	2440	3	_m_ixes
moire	7	10	1731	3	_moire_
mores	7	62	4964	3	_m_ores
mummies	10	38	1284	3	mummi_es
mumpers	13	33	1136	3	mumper_s
mures	7	59	3721	3	_m_ures
murices	11	26	1228	3	murices
murines	9	37	1822	3	murines
murres	8	50	1904	3	_murres
murries	9	41	1867	3	murries
muspikes	16	3	523	3	muspikes
mutines	9	31	1782	3	mutines
ombres	10	39	1113	3	om_bres
opines	8	48	2070	3	_opines
orpines	9	44	1479	3	orpines
outfires	11	3	986	3	outfires
pares	7	71	6448	3	__pares
peres	7	62	4664	3	__peres
piers	7	59	2633	3	__piers
pies	6	69	4960	3	__pi_es
pikes	11	50	3103	3	__pikes
piles	7	47	4261	3	__piles
pines	7	60	4886	3	__pines
pipes	9	60	3014	3	__pipes
pirns	7	60	2009	3	__pirns
pixes	14	43	2317	3	__pixes
pores	7	58	4903	3	__pores
pries	7	43	3953	3	__pries
pumices	13	3	827	3	pum_ices
pumpers	13	31	1367	3	pumper_s
puppies	10	32	1261	3	puppi_es
purpures	12	7	614	3	purpures
pyres	10	55	2388	3	__pyres
quires	15	40	1573	3	_quires
rampikes	16	3	539	3	rampikes
rapiers	9	50	1287	3	rapiers
rapines	9	51	2086	3	rapines
refires	10	48	2031	3	refires
rehires	10	50	1611	3	rehires
repines	9	49	2738	3	repines
respires	10	3	1190	3	respires
retires	7	47	2621	3	retires
rewires	10	47	1711	3	rewires
rimfires	13	4	420	3	rimfires
rummies	11	32	1279	3	rummi_es
rumples	11	33	1313	3	rump_les
rumpuses	12	3	516	3	rumpuses
samphires	16	4	551	3	samphires
satires	7	26	1757	3	satires
shires	9	52	2557	3	_shires
sires	5	59	4537	3	__sires
smiles	8	45	2229	3	sm_iles
smirks	12	49	1012	3	sm_irks
smites	8	39	2192	3	sm_ites
sopites	9	38	1717	3	sopites
spares	8	48	3455	3	_spares
spices	10	43	2603	3	_spices
spiers	8	44	2174	3	_spiers
spies	7	60	3762	3	_spi_es
spikes	12	45	2071	3	_spikes
spiles	8	42	2791	3	_spiles
spines	8	51	3203	3	_spines
spire	7	58	2869	3	_spire_
spirea	8	40	1563	3	_spirea
spireas	9	44	1251	3	_spireas
spired	9	49	2186	3	_spired
spirem	10	42	1416	3	_spirem
spirems	11	49	956	3	_spirems
spirts	8	53	1713	3	_spirts
spites	8	41	2733	3	_spites
spores	8	47	2661	3	_spores
squires	16	38	1283	3	squires
sumpters	12	3	802	3	sumpters
supines	9	42	1638	3	supines
suspire	9	3	780	3	suspire_
suspired	11	3	560	3	suspired
tapirs	8	41	1317	3	tapir_s
tapises	9	29	1401	3	tapises
tires	5	54	3749	3	__tires
tummies	11	30	1203	3	tummi_es
tumplines	13	4	602	3	tumplines
uglies	7	4	1232	3	ugli_es
umbered	12	15	1011	3	umbered
umbers	10	42	1520	3	umber_s
umbles	10	38	1748	3	um_bles
umbones	11	3	801	3	umbones
umbras	10	3	863	3	um_bras
umiacs	10	3	566	3	um_iacs
umiaks	12	4	495	3	um_iaks
umiaqs	17	3	300	3	um_iaqs
umped	10	47	1727	3	ump__ed
umping	11	48	1532	3	umpi_ng
umpirage	13	4	357	3	umpirage
umpiring	13	3	609	3	umpiring
umps	8	57	2194	3	ump___s
umpteen	11	4	384	3	umpteen
unaired	8	29	1601	3	unaired
undies	7	38	2196	3	undi_es
undines	8	7	1608	3	undines
unfired	11	22	1245	3	unfired
unfixes	17	23	811	3	unfixes
ungirds	9	10	530	3	ungirds
unhired	11	25	1215	3	unhired
unites	6	50	2485	3	u_nites
unlives	10	20	1095	3	unlives
unmitres	10	3	686	3	unmitres
unmixes	16	19	775	3	unmixes
unpaired	11	20	894	3	unpaired
unpicks	15	4	518	3	unpicks
unpile	8	19	1432	3	unpile_
unpiled	10	23	1274	3	unpiled
unpins	8	23	1238	3	unpi_ns
unpure	8	29	1153	3	unpure_
unties	6	43	2692	3	unti_es
untired	8	23	1638	3	untired
upases	8	41	1290	3	u_pases
updives	13	3	471	3	updives
updries	10	20	908	3	u_pdries
upgirds	11	10	307	3	upgirds
upgrew	12	3	365	3	u_pgrew
uphroes	12	3	630	3	u_phroes
uppers	10	29	1228	3	upper_s
uppile	10	17	850	3	uppile_
uppiled	12	21	659	3	uppiled
uppings	12	25	712	3	uppings
uprise	8	23	1369	3	u_prise
uprises	9	20	1273	3	uprises
upsides	10	31	963	3	upsides
upsizes	18	29	716	3	upsizes
uptimes	11	7	754	3	uptimes
urares	6	45	1909	3	u_rares
ureides	8	3	1110	3	ureides
urines	6	47	2412	3	u_rines
usuries	7	5	1063	3	usuries
vampire	14	29	667	3	vampire_
venires	10	30	1245	3	venires
vires	8	45	2968	3	__vires
wires	8	60	3491	3	__wires
yummies	14	35	953	3	yummi_es
yuppies	14	33	926	3	yuppi_es
zaires	15	3	970	3	_zaires

Search took 9 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	134027	0.170	1051123.5
2	DLD Change Limit	134027	306	7.796	17191.8
3	Display Results	306	306	0.126	2428.6
	(SQL Overall)	178691	306	8.092	22082.4