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

125 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
porkpies163619(None) 
porkies133416491pork_ies
porkpie1544671porkpie_
pokies125921332po_k_ies
poppies102816192po_ppies
porgies103017002por_gies
porkier133712342pork_ier
porkiest143513712pork_iest
potpies113116172po_tpies
birkies133712433birk_ies
bookies133819403book_ies
cockpits1845743cockpits
cookies133719273cook_ies
copies104130303co__pies
corbies113520123cor_bies
corkages1539103corkages
corkier133114303cork_ier
corkiest143114793cork_iest
corodies11313693corodies
corpses113913803cor_pses
corries94026793cor_ries
cowpies143314283co_wpies
croppies143111133croppies
darkies124015753dark_ies
dories75232363dor__ies
dorkier122810023dork_ier
dorkiest133111253dork_iest
folkies143612253folk_ies
forcipes1535943forcipes
forkier144311593fork_ier
forkiest153812303fork_iest
forties104323863for_ties
groupies1137523groupies
harpies123818313har_pies
honkies143015143honk_ies
hookies144017443hook_ies
hornpipes1652933hornpipes
jerkies183411583jerk_ies
koppies153210013ko_ppies
lories64933043lor__ies
lorries74518343lor_ries
nookies113414963nook_ies
orgies72316093_or_gies
orpines94414793_or_pines
orpins83614163_or_pins
pappies103214823p_appies
paries84742513par__ies
parities10522973parities
parkades1538273parkades
parodies11313693parodies
parries93925843par_ries
parties93230863par_ties
perkier133813123perk_ier
perkiest143313243perk_iest
perries93226603per_ries
perspires1346663perspires
phoresies1447993phoresies
pinkies133818263pink_ies
piracies12312643piracies
pirogies1139423pirogies
pockier153911603pock_ier
pockiest163412053pock_iest
poesies93217403po_esies
poetries10315583poetries
pogies94123543po__gies
pokes116133013po_k__es
pokier124914633po_k_ier
pokiest133314913po_k_iest
policies122415663policies
polies84034583po__lies
polities102722343polities
polypides1747073polypides
pommies133712843po_mmies
ponies84833463po__nies
poperies12316793poperies
popes95933813po__p_es
poppied11388983po_ppied
popples103011873po_pples
popsies112816463po_psies
porches143815673por_ches
porcupines1642823porcupines
pores75849033por___es
porked134717623pork__ed
porker124917543pork__er
porkers134314933pork_ers
porkiness15249193porkiness
porking143515813pork_ing
porks115124143pork___s
pornier93413133por_nier
porniest103214313por_niest
porpoise1248083porpoise
porpoises1348433porpoises
portages112613223portages
portlier1038373portlier
portliest11310183portliest
posies84431433po__sies
posties93128813po_sties
potpie103412433po_tpie_
potsies93019483po_tsies
potties93723543po_tties
poussies1038113poussies
premies113823063p_remies
preppies1149683preppies
prexies163415003p_rexies
pries74339533p_r__ies
privies122414263p_rivies
propines122618933p_ropines
prossies101515223prossies
prosties101421193prosties
proxies163014933p_roxies
punkies134216803punk_ies
puppies103212613p_uppies
purifies13311923purifies
purities10316283purities
purples112712833pur_ples
pyropes142210193pyrop_es
rookies113917103rook_ies
scrapies124612473scrapies
sorties74126403sor_ties
tories65435883tor__ies
torpids1037373tor_pids
workpiece2052013workpiece
workpieces2161963workpieces
worries104117133wor_ries
worthies14310283worthies

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.423422437.4
2DLD Change Limit1461621256.73321708.3
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.20224811.3
 
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.