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 “empires” 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.

347 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
empires113985(None) 
empire1039321empire_
expires1638681expires
umpires1137811umpires
amperes11313982amperes
aspires9612042aspires
bemires113212832bem_ires
emeries91620022emeries
emigres1037672emigres
emirs76116162em_ir_s
empales112411432empales
emperies12314562emperies
empiric1345962empiric
empirics1444002empirics
empress1138162emp_ress
emprise11310722emprise
emprises12311002emprises
emprizes2138132emprizes
emptiers1275192emptiers
empties11712242empties
entires71517782entires
espies83716802espi_es
expire1538022expire_
expired1736402expired
expirer1635992expirer
expirers1735122expirers
expiries1747752expiries
lempiras1243852lempiras
mires75640882_m_ires
moires8915632_moires
respires10311902respires
spires84628112_spires
umpire1047892umpire_
umpired1235782umpired
vampires15226032vampires
admires1038663admires
alpines94016193alpines
ambries111614553ambries
amices105018013am_ices
amides95722663am_ides
amies76837693am_i_es
amines84727983am_ines
amirs75924923am_ir_s
ammines11312673ammines
ampere10514413ampere_
ampules1189433ampules
apices104916263_apices
apres75426403_ap_res
armoires1057623armoires
aspire8612123aspire_
aspired1068173aspired
aspirer967903aspirer
aspirers1066493aspirers
aspises9611643aspises
attires72312953attires
bemire103312803bem_ire_
bemired123410633bem_ired
bemixes18338653bem_ixes
campfires1844123campfires
camphires1845783camphires
capizes20410373capizes
cires74932913__cires
compares143816433compares
comperes143217973comperes
compiles14311983compiles
copiers114215963copiers
copies104130313copi_es
cypres1338523cyp_res
demies94825803dem_i_es
demirep1236213dem_irep
demireps1343993dem_ireps
demises103719563dem_ises
desires81316133desires
despises1139433despises
despites11410313despites
eagres74014573e_agres
easies64126633easi_es
eddies83313163eddi_es
ediles74016983e_diles
egises7312493e_gises
elides74420693e_lides
elites66027123e_lites
emailed10359213emailed
emails84412343emai_ls
embarks15337353embarks
embars103812883embar_s
embers104116183ember_s
embrues1136473embrues
emcees1037813em_cees
emeers83314183emeer_s
emerges101310883emerges
emes65434663em___es
emeses86114963em_eses
emetines10611053emetines
emeutes938013emeutes
emigre937053emigre_
emir65918703em_ir__
emirates101214853em_irates
emits75421473em_i_ts
emmers104013223emmer_s
emoters94712873emoters
emotes84620283em_otes
empale102611263empale_
empaled12288953empaled
empaler11288353empaler
empalers12226743empalers
empanel1145963empanel
empanels1244823empanels
emperor1155483emperor
emperors1256123emperors
empery1348683emper_y
emphases1568353emphases
emplaces1438413emplaces
emplanes1239503emplanes
employes1555943employes
employs1455523employs
emporia1148753emporia
empower14217033empower
empowers15276843empowers
emprize2038843emprize
emptied1297403emptied
emptier1187603emptier
emptiest1278103emptiest
emptiness1335373emptiness
emptings1364823emptings
emptins1179403emptins
empurples1542013empurples
empyreal1542673empyreal
empyrean1542273empyrean
empyreans1641883empyreans
emydes1236173em_ydes
encores9315213encores
endites83717063endites
endives113710693endives
endures83314603endures
engines81114463engines
engirds995053engirds
enquires17276973enquires
ensiles72714833ensiles
ensures73315903ensures
entices91616333entices
entire61617703entire_
entries71523163entries
enures63919713e_nures
enviers1036993enviers
envies9314053envi_es
enviros1034913enviros
eosines73718293eosines
epees75219833e_p_ees
epics95014283e_pi_cs
epicures1246513e_picures
epimer10109153e_pimer
epimeres12117653e_pimeres
epimers11109493e_pimers
epodes94315563e_podes
eposes84418783e_poses
equines161811593equines
equites162212493equites
ermines9416673ermines
espials937093espials
espied9359783espi_ed
esprits938393esprits
esquires17266213esquires
etoiles7411293etoiles
euchres1288663euchres
euphroes1345993euphroes
evites94916473e_vites
excides1738343excides
excises1638933excises
excites16310633excites
exiles134816403e_xiles
exines135715803e_xines
experts1659063experts
expiates17810213expiates
expiry1834653expir_y
explores1746253explores
exports1647983exports
exposes1639963exposes
express1637493exp_ress
eyres84921773e__yres
eyries93816813eyri_es
fires85740753__fires
glaires84010143glaires
hemlines13310623hemlines
hempie132410563hempi_e_
hempier14319003hempi_er
hempiest1539043hempi_est
hires86134343__hires
imbibes1334693imbibes
imides94515343im_ides
imines84918353im_ines
immies102412443immi_es
immixes1835073immixes
immures1136713immures
impaired1335143impaired
impairer1244863impairer
impairers1343713impairers
impairs1135823impair_s
impales113311763impales
imparks15276663imparks
imparts11298533imparts
impedes124310093impedes
imphees1436693imphees
impinges13297423impinges
impings12348553impings
impious1137063impious
impis96213853impi__s
implies11312123implies
implores12127043implores
impones112712253impones
imports11309623imports
imposes113213683imposes
impresa1134753imp_resa
imprese1138143imp_rese
impress1137773imp_ress
imprest11310203imp_rest
impure1038383impure_
impurer1136483impurer
impurest1245913impurest
imputes1138083imputes
inspires1037623inspires
ires45639283___ires
jemmies18318333jemmi_es
kelpies13289903kelpi_es
kewpies16246923kewpi_es
lapides103012043lapides
lapises93513463lapises
lempira1144193lempir_a
lemures938793lem_ures
lipides103810623lipides
lupines93912503lupines
madres93718183_madres
mailes84329113_mailes
mairs76228303_mair_s
maizes175115733_maizes
mares76457633_m_ares
matres84522233_matres
mbiras1077153_mbiras
memoirs1136803memoir_s
memories121214353memories
meres75143573_m_eres
merises93421423merises
metiers93312843metiers
metres85121563_metres
mikes115129893_m_ikes
miles74645073_m_iles
mimes95732023_m_imes
mines75651953_m_ines
mire66748233_m_ire_
mired85729223_m_ired
mirex146816623_m_irex
mirks115122143_m_irks
mirs66940573_m_ir_s
mises74740563_m_ises
mites75141803_m_ites
mitres83922073_mitres
mixes147224403_m_ixes
moire71017323_moire_
mores76249643_m_ores
mures75937223_m_ures
murres85019043_murres
ombres103911143om_bres
opines84820703_opines
orpines94414793orpines
pares77164483__pares
pemphixes2543003pemphixes
peres76246643__peres
perspires1346663perspires
piers75926333__piers
pies66949603__pi_es
pikes115031033__pikes
piles74742613__piles
pines76048863__pines
pipes96030143__pipes
pirns76020093__pirns
pixes144323173__pixes
pores75849033__pores
pries74339533__pries
pyres105523883__pyres
quires154015753_quires
rampikes1635393rampikes
rapiers95012873rapiers
rapines95120863rapines
refires104820313refires
rehires105016113rehires
remiges103015473rem_iges
remises93423483rem_ises
remixes164313873rem_ixes
repines94927383repines
requires17168703requires
respire9411543respire_
respired1148993respired
respites10513243respites
retires74726213retires
rewires104717113rewires
rimfires1344203rimfires
samphires1645513samphires
satires72617573satires
semipros1244483semipros
semises93916553sem_ises
sempre102710093semp_re_
shires95225573_shires
sires55945373__sires
smiles84522293sm_iles
smirks124910123sm_irks
smites83921923sm_ites
sopites93817173sopites
spares84834553_spares
spices104326033_spices
spiers84421743_spiers
spies76037623_spi_es
spikes124520713_spikes
spiles84227913_spiles
spines85132033_spines
spire75828693_spire_
spirea84015633_spirea
spireas94412513_spireas
spired94921863_spired
spirem104214163_spirem
spirems11499563_spirems
spirts85317133_spirts
spites84127333_spites
spores84726613_spores
squires163812843squires
supines94216383supines
suspires1038203suspires
tapirs84113173tapir_s
tapises92914013tapises
temperas12278233temperas
tempered13248223tempered
temperer12227723temperer
temperers13247023temperers
tempers113513013temper_s
temples112610893temp_les
tempters12257293tempters
temptress1343133temptress
tempuras12295063tempuras
tires55437493__tires
umpirages1443343umpirages
unpiles92112783unpiles
uppiles11208263uppiles
vampire14296673vampire_
venires103012453venires
vires84529683__vires
weepies122811743weepi_es
wires86034913__wires
zaires1539703_zaires

Search took 9 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 Filter1786911340270.423422437.4
2DLD Change Limit1340273477.50017870.3
3Display Results3473470.1702041.2
 (SQL Overall)1786913478.09322079.7
 
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.