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

111 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
porteress113792(None) 
portress1038311port_ress
fortress1136752fort_ress
portered112311532portere_d
porteresses1345492porteresses
porters93722702porter__s
portieres1138202portiere_s
portless10310642port_less
potterers11218652potterers
sorceress1144012sorceress
barterers11269633barterers
borderers1276333borderers
cateress102311603_cateress
coatdress1243183coatdress
coreless103013833cor_eless
corteges1198813cortege_s
cortexes1797613cortexe_s
cotterless1244023cotterless
dotterels1043903dotterels
forceless1435723forceless
fosterers12238013fosterers
horseless1237213horseless
hotpress1344293ho_tpress
loiterers936263loiterers
moreness10911573mor_eness
mortarless1243103mortarless
murderess1243593murderess
noteless839403no_teless
oratress834553_oratress
orderers9116563_orderers
orderless1044313_orderless
outdress9137313_outdress
outpress10118173_outpress
palterers11249533palterers
pantdress1243353pantdress
parterres1148043parterres
partnerless1351873partnerless
patterers112410123patterers
peeress939503p__eeress
pertness10310093pert_ness
pesterers112510443pesterers
pewterers14216043pewterers
poetess938933po__etess
poetesses1137233poetesses
poetless1038723poet_less
poitrels1035243poit_rels
poleless1089873po_leless
politeness1247983politeness
ponderers12248443ponderers
popeless1288473po_peless
porkers134314933porker__s
porkiness15249193porkiness
portages112613223portage_s
portends11358963porte_nds
portents103512823porte_nts
porter84224413porter___
porterage1245743porterage
porterages1345953porterages
portering122012303portering
portiere1038773portiere__
portliest11310183portliest
portliness1246833portliness
portrays1345293port_rays
portresses1247303portresses
posteens10309723poste_ens
posterns102713703poster_ns
posters93927993poster__s
posturers1137043posturers
postures10313763posture_s
poteens92910883po_te_ens
potteens10256793potte_ens
pottered112311663pottere_d
potterer102310263pottere_r
potteries11313593potteries
potters94024343potter__s
pottiness1179693pottiness
poulterers1244563poulterers
pouters94221863pouter__s
powderers15214783powderers
powderless1642583powderless
powerless1444293po_werless
powters124015653powter__s
precess11310863p_r_ecess
prepress12137973p_repress
prioress1035393p_rioress
procuress1344093procuress
progress1137023p_rogress
proneness11310443proneness
properest1349663properest
properness1445923properness
proteases112110823proteases
protectress1553123protectress
protegees1275393protegees
proteges1149923protege_s
proteoses112211013proteoses
proteuses11238993proteuses
pureness101110183pur_eness
putterers11238363putterers
sorcerers1145323sorcerers
soreness8914793sor_eness
sorters74221113sorter__s
sporters103714053sporter__s
sportiness1278233sportiness
torturers944343torturers
tortures838913torture_s
totterers9186813totterers
vortexes18114043vortexe_s
votaress1144223vo_taress
voteless1137493vo_teless
votress1035483vo_t_ress
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 Filter1786911486410.203880251.2
2DLD Change Limit1486411117.61019532.3
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.85922737.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.