Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

203 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
emperies1231456(None) 
emeries91620021em_eries
amberies122514682amberies
amperes11313982amper_es
aperies9423202_aperies
duperies11312812duperies
eateries8324312eateries
emerges101310882em_erges
emperors1256122emperors
empires1139852empir_es
empirics1444002empirics
emprise11310722emp_rise
emprises12311002emp_rises
emprizes2138132emp_rizes
empties11712242emp_ties
expiries1747752expiries
imperils1247712imperils
japeries17311462japeries
moperies12313872moperies
naperies10313902naperies
poperies12316792poperies
roperies10315762roperies
aeries64737783__aeries
ambaries123312383ambaries
ambries111614553am_bries
amerces1149853am_erces
amperages1447683amperages
ampere10514413amper_e_
arteries8321483arteries
asperges11318093asperges
asperses104111673asperses
bakeries14312193bakeries
beaneries11310903beaneries
boweries13312293boweries
celeries10316313celeries
cemeteries1447383cemeteries
comperes143217973comper_es
cooperies131113313cooperies
coteries10422703coteries
deaneries10310833deaneries
demerges12129503dem_erges
demerits11310763dem_erits
doweries12411933doweries
draperies1249193draperies
eerie55228533e__erie_
eerier64320023e__erier
eeriest73620673e__eriest
elderlies1044673elderlies
elegies81312903e_legies
embers104116183ember__s
embodies1337003embodies
embolies1239153embolies
embrues1136473em_brues
emcees1037813emce__es
emeerates1149373emeerates
emeers83314183emeer__s
emerge91510463em_erge_
emerged11158213em_erged
emerita938713em_erita
emeritas1046433em_eritas
emeriti949433em_eriti
emeritus1045173em_eritus
emerods10137653em_erods
emeroids11147723em_eroids
emersed10138513em_ersed
emeses86114963em_e_ses
emesis84712623em_esi_s
emetics11610723em_etics
emetines10611053em_etines
emetins9812653em_etins
emeutes938013em_eutes
emigres1037673emigr_es
emmers104013223emmer__s
empales112411433emp_ales
empathies16115403empathies
emperor1155483emper_or
empery1348683emper__y
emphases1568353emphases
empire1039323empir_e_
empiric1345963empiri_c
emplaces1438413emplaces
emplanes1239503emplanes
employes1555943employes
emporia1148753empori_a
emporium1446173emporium
emporiums1544223emporiums
empress1138163emp_ress
empresses1348163empresses
emprize2038843emp_rize
emptied1297393emp_tied
emptier1187603emp_tier
emptiers1275193emp_tiers
emptiest1278103emp_tiest
emptins1179403emp_tins
empurples1542013empurples
enemies9313693e_nemies
energies9310783e_nergies
enterics10312853enterics
entries71523163e_ntries
epees75219833e_pe__es
epergnes1156713e_pergnes
epoxies1637753e_poxies
equerries1844883equerries
eserines8413743e_serines
espies83716803esp__ies
esprits938393esp_rits
etherizes2149313etherizes
eupepsies1344073eupepsies
euphroes1345993euphroes
expedites1946163expedites
expenses17138373expenses
experted1838053experted
expertise1847933expertise
expertises1947103expertises
expertizes28106013expertizes
experts1659063exper_ts
expires1638683expir_es
externes1539833externes
eyries93816813e__yries
faeries104118993_faeries
fakeries1559833fakeries
ferneries1239043ferneries
fineries112416743fineries
fopperies1666013fopperies
graperies1239613graperies
helleries122611683helleries
henneries1248643henneries
imageries1246783imageries
immerges1345393immerges
immerses1235953immerses
impedes124310093impe_des
imperia1148423imperi_a
imperial1249023imperial
imperials1347333imperials
imperil1147683imperi_l
imperiled1445493imperiled
imperious1346583imperious
imperium1446423imperium
imperiums1544583imperiums
impieties1345963impieties
implies11312123imp_lies
impreses1238093impreses
lamperses1345123lamperses
lecheries1449073lecheries
liveries11314373liveries
marries93825283_marries
memories121214353memories
merceries13410043merceries
merces105720743_m_erces
mercies113817563_m_ercies
merdes94518603_m_erdes
meres75143573_m_er_es
merges94122493_m_erges
merises93421423_m_erises
merits8320873_m_erits
merles85322763_m_erles
miseries10320403miseries
mummeries1247243mummeries
murries94118673_murries
niteries8318383niteries
orreries8310123orreries
paries84742513__paries
pedleries1298783pedleries
peeries93623023_peeries
peres76246643__per_es
perils84121853__perils
peris75537073__peri_s
perries93226603__perries
perses85428063__perses
pineries102419083pineries
piperines131610693piperines
pries74339533__p_ries
queries16315873_queries
remarries1147673remarries
remedies11310553rem_edies
remerges111110203rem_erges
reveries112518513reveries
roseries8317313roseries
ruderies9311333ruderies
sealeries9313133sealeries
series64540973__series
species11314133_species
stemmeries1445173stemmeries
superlies11314553superlies
temperas12278233temper_as
tempered13248223temper_ed
temperer12227723temper_er
temperers13247023temperers
tempering1438733tempering
tempers113513013temper__s
temporise1347403temporise
temporises1447243temporises
temporizes2346933temporizes
tepefies1346893tepefies
trumperies1444453trumperies
umpires1137813umpir_es
updries10209083_updries
veeries102916893_veeries
veneries112815033veneries
vineries112716043vineries
voleries11313233voleries
wineries112316533wineries
yperites13310153_yperites

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.420425454.8
2DLD Change Limit1461622036.36022981.4
3Display Results2032030.0932182.8
 (SQL Overall)1786912036.87325999.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.