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

308 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
portages11261322(None) 
portage103013641portage_
portaged12228461portaged
postages112815321postages
potages102416421po_tages
pottages112910451pottages
borages103917162bor_ages
cartages11313312cartages
cordages12310112cordages
corkages1539102corkages
corsages11310362corsages
corteges1198822corteges
cottages113310492cottages
dotages92311792do_tages
footages1239052footages
forages114217282for_ages
hostages122311692hostages
montages111412182montages
mortgages1344022mortgages
outages82317322_outages
partakes1449922partakes
plottages1244242plottages
portables1337872portables
portaled11239202portaled
portals94015562porta_ls
portances1349832portances
porterages1345972porterages
postage103214852postage_
potage92715902po_tage_
pottage103310602pottage_
protases102115032protases
proteges1149922proteges
reportages1344382reportages
rootages939102rootages
shortages1336512shortages
voltages1237252voltages
vorlages1236032vorlages
wordages1337052wordages
acreages1138373acreages
aortae65115473aorta_e_
aortas65417783aorta__s
apostates1149163apostates
barrages11711083barrages
bondages1237893bondages
boraces113716853bor_aces
borage93917013bor_age_
boranes93720403bor_anes
borates94823013bor_ates
boraxes163511633bor_axes
boreases10310253boreases
bortzes1838223bort_zes
boscages1366643boscages
boskages1565423boskages
brokages1536253brokages
burgages1236483burgages
carnages11312213carnages
cartage10312593cartage_
coinages11310803coinages
collages113514243collages
colportages1652273colportages
cordage11310063cordage_
corkage1438373corkage_
corotates112714283corotates
corrades111211263corrades
corsage1039803corsage_
cortege1098953cortege_
cortexes1797613cortexes
cortices12615013cortices
cottage104210573cottage_
cottager11306813cottager
cottagers12305383cottagers
cottagey14305233cottagey
courages11311393courages
cowages13310943co_wages
cowhages1736113cowhages
cuttages11297223cuttages
dockages1635983dockages
dosages92310803do_sages
dotage82711613do_tage_
ecotages1136973ecotages
enrages83114853enr_ages
floatages1344233floatages
flotages1237163flotages
foggages1434213foggages
foliages1247623foliages
footage1148843footage_
forage104617003for_age_
foraged124812283for_aged
forager114412563for_ager
foragers12349633for_agers
forestages1446733forestages
forges105024263for__ges
formates132814293formates
forsakes1536893forsakes
fortes95327183fort__es
forties104323863fort_ies
fortunes1158283fortunes
fromages1437073fromages
frontages13116183frontages
frottages1384993frottages
garages9314113gar_ages
garbages1238183garbages
gorges85321893gor__ges
herbages1437093herbages
heritages1346713heritages
homages131011583ho_mages
hostage113111233hostage_
lockages1536723lockages
lovages1138033lo_vages
meltages1148243meltages
metages102714973_metages
mintages111110513mintages
mirages102213533mir_ages
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
moorages1139053moorages
morales93619403mor_ales
mortals93914003morta_ls
mortared1137213mortared
mortars93411523morta_rs
mortgage1244213mortgage_
mortgaged1442543mortgaged
mortgagee1342853mortgagee
mortgagees1451703mortgagees
mortgager1342513mortgager
mortgagers1442233mortgagers
mortices12711563mortices
mortises10713613mortises
moulages1138053moulages
nonages8313843no_nages
nontaxes1537853nontaxes
notates72817483no_tates
octanes91111393_octanes
octaves12316963_octaves
ohmages13115093_ohmages
oranges84215333_oranges
orates64328613_or_ates
outage72017533_outage_
outrages92215933_outrages
packages17138733packages
pages85235073p___ages
parades104121463par_ades
parataxes1846393parataxes
parbakes1638343parbakes
parentages1345483parentages
parges94529543par__ges
parkades1538273parkades
partake1339643partake_
partaken1445553partaken
partaker1436873partaker
partakers1536563partakers
partans94418283parta_ns
parties93230863part_ies
passages1139513passages
pawnages1435313pawnages
peages94321853p__eages
pectases122411193pectases
pectates122213953pectates
peerages1189893peerages
pelages10714613p_elages
pentanes10316083pentanes
peonages1138473peonages
percales12313803percales
pertains102113423pertains
pervades1437353pervades
petrales10312983petrales
phages125213513p__hages
phorates13413043phor_ates
phrases12711463phr_ases
phytanes1645763phytanes
pillages113012613pillages
pilotages1245503pilotages
pipages1289423p_ipages
pipeages1336423pipeages
pirates93020333pir_ates
plages94520153p__lages
platanes102711883platanes
plottage1144433plottage_
plumages1335653plumages
poetises10313953poetises
poetizes19310253poetizes
poetries10315583poetries
poleaxes1767273poleaxes
pomaces132712123po_maces
pomades123711733po_mades
pontes83627853pont__es
porbeagles1561673porbeagles
porches143815673por_ches
pores75849033por___es
porgies103017003por_gies
porkies133416493por_kies
porkpies1636193porkpies
porridges1343913porridges
portable12313203portable
portably1539313portably
portaging1346843portaging
portal84218463porta__l
portance12310123portance
portapak1642343portapak
portapaks1742133portapaks
ported94223243port__ed
portends11358963portends
portents103512823portents
porter84224413port__er
porterage1245763porterage_
portered112311543portered
porteress1137933porteress
porters93722703port_ers
portholes14410373portholes
porticoes1348253porticoes
porticos1238373porticos
portieres1138213portieres
portions10514413portions
portless10310643portless
portlier1038373portlier
portliest11310183portliest
portraits1146803portraits
portrayed1564103portrayed
portrayer1464003portrayer
portrayers1553603portrayers
portrays1345293portrays
portress1038323portress
ports75934593port___s
postals93716373posta_ls
postbags1345293postbag_s
postdates1248863postdates
postfaces1656273postfaces
posties93128813post_ies
postures10313783postures
potables12179703po_tables
potashes1337833po_tashes
potatoes1039943po_tatoes
potpies113116173po_tpies
potsies93019483po_tsies
potties93723543po_tties
pottles93816983po_ttles
poundages1344153poundages
poutines102415103poutines
prases84429023p_r_ases
prates84633163p_r_ates
praxes156215183p_r_axes
preaged11612333p_reaged
presages11312203presages
pretapes122811533pretapes
primages13159273primages
probates12414283probates
profanes132311573profanes
pronates10418373pronates
propanes122415823propanes
prophages1749763prophages
prorates10418073prorates
prostates11314423prostates
protasis102411973protasis
proteases112110833proteases
protege1059153protege_
protegee1156963protegee
protegees1275393protegees
protyles13249833protyles
psoriases1144863psoriases
purges94421763pur__ges
rages64539443__r_ages
reportage1245023reportage_
restages92815773restages
rootage839053rootage_
rotates72819773ro_tates
scutages1136503scutages
septages1168263septages
serfages1238233serfages
shortage1236313shortage_
soakages1336143soakages
socages101012053so_cages
soccages1336383soccages
soilages9189673soilages
sorbates10311103sorbates
sorties74126403sort_ies
soutanes8312933soutanes
spoilages12184713spoilages
stages75629493__stages
storages9311103stor_ages
surtaxes1536513surtaxes
tentages91011043tentages
tollages92410193tollages
tonnages9187873tonnages
torsades937213torsades
tortas64918253torta__s
tortes64826053tort__es
tortures838913tortures
towages1139233to_wages
triages82613793_triages
unitages938273unitages
upstages11147373upstages
vantages12119023vantages
ventages12119773ventages
vintages12118273vintages
voltage1136863voltage_
vorlage1136403vorlage_
vortexes18114053vortexes
vortices1369123vortices
voyages1435703vo_yages
waftages15105393waftages
wantages12109023wantages
warpages1437053warpages
wastages12109753wastages
wattages12106783wattages
wordage1236503wordage_
worthies14310283worthies
yardages1336203yardages

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.440406115.9
2DLD Change Limit1461623087.07620656.0
3Display Results3083080.1232504.1
 (SQL Overall)1786913087.63923391.9
 
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.