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

209 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
empress113816(None) 
express1637491express
impress1137771impress
compress1439052compress
cypress1434652cypress
depress10239872depress
egress73310432e_gress
eldress835002eldress
empires1139852empire_s
empresses1348162empresses
emprise11310722emprise
emprises12311002emprises
espresso1043192espresso
expresso1743882expresso
impresa1134752impresa
impresas1244452impresas
imprese1138142imprese
impreses1238092impreses
imprest11310202imprest
imprests1246312imprests
oppress1135992oppress
press75425952__press
repress92712682repress
temptress1343132temptress
actress948533actress
address956103address
aggress935593aggress
amperes11313983amperes
amplest11312333amplest
ancress978613ancress
apres75426403_apre_s
bemires113212833bemire_s
capless114312763capless
caress85720263_caress
cress75022833__cress
cypres1338523cypre_s
cypreses1535143cypreses
dampness1336073dampness
decompress1742843decompress
deepness1136443deepness
demireps1343993demireps
demoness1138053demoness
demurest1137453demurest
derepress1243583derepress
digress938323digress
dress65319833__dress
duress74712063_duress
eagres74014573eagre_s
earless74316073earless
editress944933editress
eggless935663eggless
egoless836983egoless
egrets72712243e_grets
embeds11377903em_beds
embers104116183em_bers
emblems1335043emblems
emboss1087383em_boss
embrues1136473embrues
embryos1464093embryos
emcees1037813em_cees
emeers83314183em_eers
emerges101310883emerges
emeries91620023emeries
emerods10137653emerods
emersed10138513emersed
emes65434663em__e_s
emeses86114963em__eses
emesis84712623em__esis
emeus76913333em__eus
emigres1037673emigre_s
emirs76116163emir__s
emmers104013223em_mers
emmets10349153em_mets
emoters94712873emoters
emotes84620283emote_s
empalers12226743empalers
empales112411433empales
empanels1244823empanels
emperies12314563emperies
emperor1155483emperor
emperors1256123emperors
empery1348683emp_ery
emphases1568353emphases
emphasis15117673emphasis
empire1039323empire__
empirics1444003empirics
employs1455523employs
empowers15276843empowers
emprize2038843emprize
emprizes2138133emprizes
emptiers1275193emptiers
empties11712243empties
emptiest1278103emptiest
emptiness1335373emptiness
emptins1179403emptins
empyema1642643empyema
empyemas1742223empyemas
empyreal1542673empyreal
empyrean1542273empyrean
empyreans1641883empyreans
emydes1236173emyde_s
endless839833endless
engross837123engross
entrees71813773entrees
enures63919713enure_s
enureses838113enureses
enuresis845493enuresis
epees75219833e_p_ees
eposes84418783e_poses
erses55826803e__rses
espies83716803espie_s
espressos1143973espressos
esprits938393esprits
eupneas935233eupneas
excess1546053e_xcess
expels1547173exp_els
experts1659063experts
expirers1735123expirers
expires1638683expire_s
exposes1639963exposes
expressed1946213expressed
expresser1845733expresser
expresses1837863expresses
expressly2143473expressly
expressos1844553expressos
eyeless1058053eyeless
eyres84921773e_yre_s
gapless10349993gapless
hapless123311333hapless
heiress1036813heiress
helpless1335063helpless
hempiest1539043hempiest
hipless12399923hipless
hipness12277383hipness
hotpress1344303hotpress
humpless15226333humpless
imarets9138643imarets
impels10389523imp_els
imphees1436693imphees
imposes113213683imposes
impregn1243403impregn
impregns1343643impregns
impressed1446283impressed
impresses1338213impresses
improvs1435003improvs
impurest1245913impurest
ingress838653ingress
lampreys1542883lampreys
lemures938793lemure_s
limpness1246703limpness
lipless9259553lipless
mares76457633_mare_s
marses84827113_marses
meres75143573_mere_s
merest84725113_merest
mess65932433_m__ess
metres85121563metre_s
mires75640883_mire_s
morass84614503_morass
morels84820023_morels
mores76249643_more_s
mures75937223_mure_s
napless93110283napless
ogress7529503_ogress
ombres103911143ombre_s
ospreys1233143ospreys
outpress10118183outpress
peeress939503peeress
prees75937173__prees
prepress12137983prepress
preps96220693__preps
presa74319043__presa
prese75228383__prese
prest75736353__prest
prests84021263__prests
preys105717783__preys
priss74623893__priss
pross76529403__pross
pumpless14236373pumpless
redress82511873redress
reexpress1842793reexpress
regress82711453regress
remorses10311993remorses
restress82511773restress
rumpless12256543rumpless
sapless93313443sapless
seeress7311573seeress
sempre102710093sempre__
sempstress1452193sempstress
sprees85620643_sprees
stress66616673_stress
suppress1236443suppress
tempehs14325153temp_ehs
temperas12278233temperas
temperers13247023temperers
tempers113513013temp_ers
tempest1139223temp_est
tempests1234443temp_ests
temples112610893temple_s
templets12226143templets
tempters12257293tempters
tigress836093tigress
tipless92610063tipless
topless92511123topless
tress55423163__tress
umpires1137813umpire_s
undress838893undress
votress1035483votress
zipless18276303zipless

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.406440125.6
2DLD Change Limit1340272097.51617832.2
3Display Results2092090.0762750.0
 (SQL Overall)1786912097.99822342.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.