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 “portress” 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
portress103832(None) 
fortress1136751fortress
porteress1137931porteress
portless10310641portless
oratress834552_oratress
pertness10310092pertness
poetess938932poet_ess
poetless1038722poetless
poitrels1035242poitrels
porters93722702port_ers
portrays1345292portrays
portresses1247312portresses
progress1137022progress
votress1035482vo_tress
actress948533_actress
apartness1146053apartness
artless73712513_artless
boltless10338283boltless
bootless103410983bootless
bortzes1838223bortze_s
bourtrees11154013bourtrees
buttress1035883buttress
coatdress1243193coatdress
coatless1039693coatless
compress1439053compress
congress1138073congress
cordless11299963cordless
coreless103013833coreless
costless10310003costless
costrels1038933costrels
curtness1037263curtness
distress9311713distress
dottrels963493dottrels
editress944933editress
footless113710803footless
footrest11308853footrest
footrests12244503footrests
fordless12289003fordless
forkless15267433forkless
formless13248083formless
fortes95327183fort_e_s
forties104323863fortie_s
fortressed1443583fortressed
fortresses1345663fortresses
goitres8389563goitre_s
goriness9310753goriness
gormless11235443gormless
hornless1137363hornless
hostess103210243host_ess
hotness1038613ho_tness
hotpress1344303hotpress
huntress1144833huntress
hurtless11307783hurtless
jointress1643053jointress
loftless1135903loftless
lordless9277483lordless
lornness836493lornness
lostness837683lostness
mattress1036533mattress
mistress10310703mistress
mootness1036753mootness
moreness10911573moreness
mortarless1243103mortarless
mortises10713613mortises
normless10235923normless
northers1139333northers
ogress7529503_o_gress
oppress1135993_oppress
orbless937493_orbless
outdress9137323_outdress
outpress10118183_outpress
pantdress1243363pantdress
parrels94713493par_rels
partiers103514243partiers
parties93230863partie_s
partlets102811513partlets
partners102711133partners
partyers13277763partyers
parures9512693parure_s
pastless102411203pastless
pastness102510503pastness
patness92912283p_atness
peartness1137773peartness
peeress939503p_eeress
peltless10267373peltless
pertest9317043pert_est
petrels9279373p_etrels
peytrels1363373peytrels
plotless10256793plotless
poetises10313953poetises
poetries10315583poetries
pointless1135703pointless
poitrel936193poitre_l
pokiness14219863pokiness
poleless1089873poleless
pomfrets1543033pomfrets
pontes83627853pont_e_s
poorest9312773po_orest
poorness1036363poorness
popeless1288473popeless
porches143815673porche_s
pores75849033po__re_s
porgies103017003porgie_s
porkers134314933por_kers
porkies133416493porkie_s
porkiest143513713porkiest
porkiness15249193porkiness
porniest103214313porniest
porrect1159743por_rect
portages112613223portages
portals94015563port_als
ported94223243port_e_d
portend103411193port_end
portends11358963portends
portent93619643port_ent
portents103512823portents
porter84224413port_e_r
portered112311543portered
porteresses1345523porteresses
porticos1238373porticos
portiere1038773portiere
portieres1138213portieres
portions10514413portions
portliest11310183portliest
portliness1246833portliness
portrait10510323portrait
portraits1146803portraits
portray1237483portr_ay
portrayers1553603portrayers
ports75934593port___s
poshness1356653poshness
possess9419123po_ssess
posteens10309733posteens
posterns102713723posterns
posters93928013post_ers
posties93128813postie_s
posttest10410233posttest
posttests1144973posttests
posturers1137053posturers
postures10313783posture_s
poteens92910883po_teens
pothers123818623po_thers
potteens10256793potteens
potterers11218663potterers
potters94024343po_tters
potties93723543pottie_s
pottiest102815973pottiest
pottiness1179703pottiness
pottles93816983pottle_s
potzers184010543po_tzers
pourers93513673po_urers
pouters94221873pout_ers
poutiest103016793poutiest
powerless1444293powerless
powters124015663powt_ers
precess11310863p_recess
prepress12137983prepress
press75425953p___ress
prestress1138133prestress
prioress1035393prioress
process11310403p_rocess
procuress1344093procuress
profess1237713p_rofess
protases102115033protases
proteas92015123prot_eas
protest9317533prot_est
protests10310493prot_ests
proteus92511593prot_eus
protheses1449073protheses
prothesis1449433prothesis
prowess1237903p_rowess
pureness101110183pureness
purtiest102414113purtiest
restress82511773restress
rootless83910443rootless
shortness1236733shortness
softness1136433softness
sorceress1144013sorceress
soreness8914793soreness
sorrels7310723sor_rels
sorters74221133sort_ers
sorties74126403sortie_s
sporters103714063sport_ers
sportiest111711033sportiest
sportiness1278233sportiness
spotless1037043spo_tless
spoutless1134243spoutless
stress66616673__stress
tartness82210133tartness
tortes64826053tort_e_s
torturers944343torturers
tortures838913torture_s
tress55423163___tress
unstress837373unstress
victress1344523victress
votaress1144223votaress
waitress1135223waitress
wardress12256163wardress
wartless11279923wartless
wordless12258843wordless
workless15276803workless
wornness1136363wornness
worthless1544923worthless

Search took 8 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 Limit1461622037.44019645.4
3Display Results2032030.0762671.1
 (SQL Overall)1786912037.93622516.5
 
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.